Calculaction Correction in BW Report
How can i achieve the following calculaction in BW Reports
Col C = needs to be always positive (Col A - Col B)
Total for Col C = Sum of all values in Col C
Please advise how to perform this calculaction
Thanks in advance
Create a Calculated Keyfiegure C = A-B and it will give the difference of A and B.
Then try using Absolute function : ABS(C) : all the values of C will be positive.
But for the Total valuse of C : As far as i know by default the absolute function works only as display purpose while calculating the total it will consider the actual values.
I had the same problem in BW 3.0 but dint try in BI 7.0
In BI 7.0 ,create a one CKY Keyfigure at run time and use the excel funtionality to get this.