Issues converting number into a percentage

[geleigh]

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%.

[Daryl-Lynch-Bzy · Accepted solution]

@geleigh - 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?

[geleigh]

So if i change the formula to 

Hours_Actual divided by Hours_Budget =

DIVIDE(SUM('Projects'[Hours_Actual]), SUM('Projects'[Hours_Budget])) * 100 it is still showing the incorrect amount.

[geleigh]

Of course I just needed to change the number format - sometimes it's that obvious. Thank you!