Hello, I'm no math whiz, but I think these equations aren't quite right 😃 I've created a calculated field to subtract the Actual Hours from the Planned Hours to then be able to run a report and give us a metric of Active projects falling out of scope. However, the calculation in that field doesn't seem to make sense when I run the numbers myself. Ex: 21.5-72.75= -3075 doesn't seem accurate. I've also tried a calculated filed to subtract Planned Hours from the Actual Hours. But no dice. Technically, it is pulling out the right projects that fit the bill of being over scoped hours, but it's not giving me the actual hours the project(s) have gone over. What would you recommend in this situation? Many thanks, Lila Lila Whitney Discover Financial Services
Topics help categorize Community content and increase your ability to discover relevant content.
Thank you for the suggestion! We eventually figured out that it was minutes and had the same thought to divide by 60 but no luck. I'll keep exploring. Thank you! Lila Whitney Discover Financial Services