Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

DIV Calculated field on project form - Percent is incorrect

Avatar

Level 3

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
2 Replies

Avatar

Community Advisor

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)

Avatar

Level 3

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!! :):)