Expand my Community achievements bar.

# Workfront

SOLVED

## DIV Calculated field on project form - Percent is incorrect

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

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)

2 Replies

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)

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