in a chart, I am trying to calculate one column in a chart as a % of another, and I get incorrect result.
though it is calculating incorrectly
My sum is Column(2) / Column(1)
and I'm showing it as %
what am I doing wrong??
Setting -> Right Click Chart-> Number -> untick -> Show in Percentage %
= ( Column(2) / Column(1))*100
Hope this helps you.
Hi Vikas thanks,
I mean the values are incorrect - if you calculate them manually you will see they're differnt
Seems like you have enabled the Relative property in the expressions tab.
Not sure if you really wanted it, if not disable tht and you will get correct % values.
Please find the attached file Hope it will helps you
Thanks and Regards,
Retrieving data ...