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.