**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