Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!
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.
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)
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)
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!! :):)