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 computations

Started by kgcruz06, 21 May 2019 01:32:26 AM

Previous topic - Next topic

kgcruz06

Hi,

I'm developing a report in which I need to display Daily and Cumulative calculations. For the Daily computations, it is all showing correctly since it will just sum up and calculate base on the day, but for the Cumulative calculations in which I use the RUNNING-TOTAL() function, the results were all off.

I have 3 pairs of Daily and Cumulative calculations with different sets of dimension but have the same Date column. My suspect is that the Cumulative calculation is becoming inaccurate because of the added dimensions or columns (SEVERITY and %MET) in the report.

I've attached a sample excel. the dashboard sheet is what I would want to achieve and the details sheet is the source of the dashboard.

Kindly advise on how I can fix this. Thank you very much!