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

Be the first to reply!

Reply