COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Sep2013 on 25 Feb 2013 09:46:24 PM

Title: wrong percentage values
Post by: Sep2013 on 25 Feb 2013 09:46:24 PM
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
Title: Re: wrong percentage values
Post by: adik on 26 Feb 2013 12:43:26 AM
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 [...])