DIV Calculated field on project form - Percent is incorrect | Community
Skip to main content
KatColbourn
KatColbourn
Level 2
December 6, 2022
Solved

DIV Calculated field on project form - Percent is incorrect

  • December 6, 2022
  • 1 reply
  • 789 views

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
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Heather_Kulbacki

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)

1 reply

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity AdvisorAccepted solution
Community Advisor
December 7, 2022

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)

KatColbourn
KatColbournAuthor
Level 2
December 13, 2022

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

Terms & ConditionsAccessibility statement

Loading footer...