Calculation for %Difference

[yogeswari]

Hi,

There are certain columns in the report namely Current YTD, Previous YTD, Difference, %Difference.
Current YTD-->brings data related to current year.
Previous YTD-->brings data related to previous year.
Difference-->Current YTD-Previous YTD
%Difference-->(Current YTD-Previous YTD) divided by absolute value of Previous YTD times 100 rounded {Requirement}
                -->((Current YTD-Previous YTD)/abs(Previous YTD))*100 {calculation defined in the report}

Please confirm whether this calculation is correct or wrong?
What property has to be set for Aggregate and Rollup-Aggregate for column %Difference?

When Previous YTD=0 then what would be value of %Difference?

Please suggest.


Thanks,
Yogeswari

[AnalyticsWithJay]

Hi,

It should be set to Calculated.

When you assign this property as Calculated, you are telling Cognos that all the items within this calculated expression are aggregated according to their own rollup properties, and then those aggregated values are computed for this expression.

If you're working with charts and crosstabs and your measures follow a certain order of calculation, you may have to set the Solve Order property as well.