Hi,

I need to add a list of values in a BW SAP BEx report where the number of rows changes evertime the report is run (for a different period).
The values that needs summing, are SHOWN as positives in the report, but the actual value (positive or negative) depends on the cell value in another column. A denotes negative value, B denotes positive value.

Column 1 Report Value Actual Value (not shown in report)
A 15 -15
B 5 5
B 2 2
A 7 -7
B 8 8
A 19 -19
summation 56 -26
How do I go about entering a macro in the spreadsheet where the SUM for the Report Value column will be the absolute value of 26 and which can be used independent of the number of rows in the report?

Any help is very much appreciated!

Thanks