Calculaction Correction in BW Report
Hi Experts
How can i achieve the following calculaction in BW Reports
ColAColBColc (AB)
Row1
100
Row2
200
Row3
200
Row4
300

Total800880320
Calculactions:
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
AAAA A replied
Hi,
Try this,
Create a Calculated Keyfiegure C = AB 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.