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

Roll up Percentages

Started by mrcool, 05 May 2016 08:17:49 AM

Previous topic - Next topic

mrcool

Hi All,

I have faced an issue with percentage roll-up in active reports earlier and IBM has advised us to raise it as an enhancement request.
It looks the same issue exists in Data modules as well.In one of the analyticzone videos,For the calculations like Profit/Revenue they are advising to use "Average" for these kind of calculations.
I am not sure how that is going to work. Average is completly different to aggregating the measures and dividing them.
Can you please advise if there is any other way to handle these kind of measures in Dashboards? In reports I am using layout calculation and it worked.

Thanks,
Mc

bus_pass_man

Did you try aggregate then calculate?  Rather than try to aggregate the percentage calculation itself, create an expression with your two measures as the operands.

For example like this below.   A and b are aggregated and then the calculation is performed on the aggregated values.

a       b               a/b
2   10      0.2      
3   5      0.6      
5   20      0.25      
                            average (a/b)
10   35      0.285714286      0.35