Summing up of percentage keyfigures

[former_member218157]

Hi Experts,

We have a percentage keyfigure in our report and when we try to remove the drill down the fields, the percentage value gets added up and ends up with incorrect values as below. But we prefer to have an average value.

Order No  Region   Percentage

100           ASIA     75

101           ASIA     75

Region    Percentage

ASIA          150

Expected Result

Region    Percentage

ASIA           75

Please help out with your suggestions to avoid such Summing up of percentage keyfigures and some way to get just the average value instead of sum.

Regards,

Eshwari.

[former_member199945]

Hi,

Put order no as constant selection for Percenatge and try it once.

otherwise need to use exceptional aggregation as suggested by others.

Regards,
Seshu.P

[Former Member]

Hi Eshwari,

Put Exceptional Aggregation on Percentage, but you need to specify a characteristics on which this aggregation should work. Search for Exceptional Aggregation you will get a lot details.

Regards,

Ganesh

[anshu_lilhori]

Hi,

Make a new formula and put your percentage Kf inside it--Hit the aggregation tab--Exception aggregation as Average of all values--Reference characteristic as Order no.

Hope this helps.

Regards,

AL