DIV Calculated field on project form - Percent is incorrect

[katc13840706]

Hello Everyone!

Wondering if anyone has encountered this issue.  I have a basic DIV calculation on a form feeding a capacity report that should provide a percent of the resources "used".  The percentages on the report do not seem to be accurate.  I'm wondering what I am doing wrong.

Here is the text formatted as a number: 

DIV({actualWorkRequired},18432)

The calculation of 42.25 hours / 18432 is amounting to .14%

It should be amounting to .23%

The goal is to have a Portfolio-level percent of the resources used for all projects within it.

Thank you!

Kat

[Heather_Kulbacki · Accepted solution]

Are you getting a result of .14% or a result of .14?

I do get .23% when I do 42.25/18432 (which equals .0023 or .23%)

I'm guessing you're getting .14 (which equals 14%) because actualWorkRequired is in minutes so you're dividing the minute equivalent of 42.25 hours by 18432.

In order to divide hours by 18432, try: DIV(DIV({actualWorkRequired},60),18432)

[katc13840706]

Heather thank you so much!  You are 100% correct - I didn't take the 'minutes' into consideration when using ActualWorkRequired.  I used your calculation and added *100 and now the percent is correct.  Thank you so much for taking the time to reply!  You have rescued my reports!! :):)