Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Issues converting number into a percentage

Hi team,

I'm trying to calculate the percent of hours used over the hours budget which I was able to accomplish using DIVIDE.

When I go into 'show as a percent of grand total' it is showing the incorrect amount. How do I avoid this?

When I convert this column to a percent the numbers are not equal - what am I doing wrong? Thanks!

does not equal

So on the first line it has 6.05 and I need it to show 605%.

Anonymous
4 years ago
Anonymous - I am not sure what you mean by "Percentage of Grand Total". If you convert the Number formatting from Decimal to Percentage then 6.05 will become 605%. But changing the measure to "Percentage of Grand Totals" is different Measure. 605% as Percentage of X?