If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Running Total and Total

Started by Good Friend, 11 Apr 2016 10:49:42 AM

Previous topic - Next topic

Good Friend

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