Skip to Content
0
Former Member
Apr 28, 2009 at 12:20 PM

Calculaction Correction in BW Report

34 Views

Hi Experts

How can i achieve the following calculaction in BW Reports

Col-A Col-B Col-c (A-B)

Row1--


100 80 ---20

Row2--


200 100 --100

Row3--


200 400 --200

Row4--


300 300 --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