Skip to Content
0
Former Member
Sep 22, 2010 at 09:44 PM

Crosstab Percentage Formula

19 Views

I am trying to calculate percentage in a Crosstab. But I am getting wrong results. Here is the desired report results

...........................ACTUAL.......TARGET.....PERCENTAGE

..................................................................................................

-


North East .........100.................80.............25%

South East.........200.................120 ..........67%

West.................200 .................180...........11%

Central.............200...................250.......... -20%

-


Here is the formula for Percentage. This formula gives wrong results in Crosstabs. But gives correct results if used in a Sub-Report or main report. It has Percentage Difference calculation.

((sum({@Actual},) - sum({@Target},)) / sum({@Target},REGION}))*100

Edited by: Shamanthreddy on Sep 22, 2010 11:45 PM

Edited by: Shamanthreddy on Sep 22, 2010 11:46 PM

Edited by: Shamanthreddy on Sep 22, 2010 11:46 PM