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

wrong percentage values

Started by Sep2013, 25 Feb 2013 09:46:24 PM

Previous topic - Next topic

Sep2013

Hi,

I am calculating a variance that uses division.
But the calculation goes wrong for the total column.
PFA the output and advice the solution

adik

set the solve order property of the total row to 0 and the solve order of the column to 1
or
set the formula for the total row instead of total(currentMeasure within detail [...]) to aggregate(currentMeasure within detail [...])