Skip to main content

**EDIT:  The title should read “Effort to Duration Ratio”.  I don’t appear to be able to edit the title**

Hello everyone.

I want to produce a report that shows a ratio of how long it takes to deliver a project vs how much effort was assigned to it.

I’d also like to assign the same formula to actual cost vs budget assigned.

For example:  100 hours assigned but 200 hours duration would be a ratio of 2 - its taken twice as long to deliver as the hours assigned.  

This is a key metric for us at it allows us to see how quickly we can deliver projects.

The calculation is simple enough - $Duration / $BudgetedHours.  But I receive the following error:
 

“Error: Formula evaluation result data type is Numeric instead of expected Duration"

 

Thanks for any assistance

Hi Martin - To resolve this, you need to ensure that the field where you are applying the formula is set to accept numeric values if the result is intended to be a ratio or numeric value.or your specific calculation of the ratio of project delivery time versus effort assigned, you should ensure that the field type is set to numeric rather than duration. The formula you mentioned, $Duration / $BudgetedHours, is correct for calculating the ratio, but it must be applied in a field that accepts numeric data types.

If you need to track these metrics as key performance indicators, consider setting up custom fields that are specifically designed to capture numeric ratios rather than durations. This will prevent the error and allow you to analyze the data effectively.