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

Calculating Running-percentage or percentage growth

Started by someonear, 08 Jan 2009 02:12:44 PM

Previous topic - Next topic

someonear

All

this is the  scenario I want to create

Week - Amount  - Growth % 
1       - 50        - NULL
2       - 40        - (40-50)/50
3       - 80        - (80-40)/40
4       - 90        - (90-80)/80

I am using a list report in 8.2 environment (Report Studio)

I have created a separate col. X  where X = running-difference([amount] for [week])

and now trying to create Growth % as  =  X/(Amount-X)

Though X is displaying the correct value but the numbers for Growth %  looks to be off

Is there any other way  to solve this issue?

Thanks much