COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Good Friend on 11 Apr 2016 10:49:42 AM

Title: Running Total and Total
Post by: Good Friend on 11 Apr 2016 10:49:42 AM
Hello Everyone.. I have three data items and it has the below values. I want to get the Total of (Data item 1 minus Data item 2 minus Data item 3)as shown below.I'm using running total to sum the Data item 1 values and unable to do minus for Data item 2 and Data item 3. Can some one please help me in achieving the below logic at your earliest convenience. Thanks.

Data item 1 Data Item 2 Data item 3   Total
200               -                 -                    200
100               -                 -                    300
  -                   50              -                   250
-                    -                  50               200
50                  -                    -                250
-                    200              100              -50
200                 -                   -                150