Expand my Community achievements bar.

The Workfront Coffee Break on top takeaways from Adobe Summit is right NOW!
SOLVED

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
1 Accepted Solution

Avatar

Correct answer by
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)

View solution in original post

2 Replies

Avatar

Correct answer by
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!! :):)