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

Delta calculation

Started by raghunori, 22 Jun 2023 09:28:00 AM

Previous topic - Next topic

raghunori

Hello Cognos experts..I have a crosstab visual in Cognos dahsboard which shows opening balance and ending balance month to month. Ideally, ending balance of previous month should be equal to opening balance of current month but we end up getting some delta. So i need to show this delta which is difference between opening balance of current month and ending balance of previous month as shown below. I am struggling with the calculation. can you suggest how to accomplish this?

   Month1   Month2   Month3
         
opening balance   180   203   206
         
ending balance   200   205   

Delta.                        3        1