diff() instead of sum()

Hi,

does anybody know, if it is possible to get a difference in a table in BO, like it is possible to sum up the rows or columns of a table. I am looking for a feature which i know from Excel. Just click on a cell and write which other cells you would like to add or subtract.

Thanks
Stephan


Listserv Archives (BOB member since 2002-06-25)

Maybe you could create a new column in your report and make its formula equal to the column you’re interested in times -1. Then you can do a sum() on the column. You may want to see if you can keep the first item in the column as a positive number, though.


Listserv Archives (BOB member since 2002-06-25)