Skip to Content
0
Former Member
May 12, 2008 at 03:46 PM

Problem with Percentage Share(%A) calculation

24 Views

Hi,

I have a formula in one of my queries which uses Percentage Share(%A). The issue is, it is not displaying correct values if the result is a positive figure i.e if X %A Y is a negative value, say -1.2%, then it is displaying correctly. But if X %A Y is a positive value, say 0.32%, then it is displaying it as 0.00%. Below is the example I have:

X| Y| Result

-5.452.560| 26.398.167| -20,66 %

-107.936| 150.051.550| 0,00 %

Could someone please help me in figuring out why this is happening.

Best Regards,

Nene.