Calculated Expression - Difference Between Planned and Actual Hours (View)

[sydneyp50459827]

Does anyone know the expression required to show the difference between the planned and actual hours on a project and on a task as a view? I am trying to add this to a view on the projects global nav tab and on individual projects, but I can't get it to work. The API seems to have a lot of options for hours, so it I'm probably using the wrong fields and / or my text mode is incorrect because the "Hours Difference" column is returning some weird numbers. Any insight is appreciated! Sydney Sydney Peterson Diversified Communications, Inc.

[DagmaraGa]

Hi Sydney, We've got a field created which tells us what's the difference between Planned and Actual Hours. Actual Hours - Planned Hours. Shows a positive number for tasks where the hours are more than expected (i.e. overspent) ROUND((Actual Hours -Planned Hours)/60,2) Hope that helps. Dagmara Garwell BAKKAVOR LTD