Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculaction Correction in BW Report

Hi Experts

How can i achieve the following calculaction in BW Reports

Col-ACol-BCol-c (A-B)

Row1--


10080---20

Row2--


200100--100

Row3--


200400--200

Row4--


300300--0

-


Total----800---880-320--

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

Former Member
Former Member replied

Hi,

Try this,

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question