Hi!
I’ve built some project boards that are essentially a tasks gantt with due dates.
I’ve added two number columns for working hours- one for planned working hours and the other for the actual worked hours.
I have a high level board that mirror the important columns from each board.
Now I want to calculate the % of the Done tasks worked hours out of the planned hours.
For calculating the planned hours I’m using the formula IF({status}=“done”,SUM({planned hours}),0)
For calculating the worked hours I’m using the formula IF({status}=“done”,SUM({worked hours}),0)
And finally for calculating the % of worked hours out of planned hours I’m using the formula
DIVIDE({worked hours},{planned hours})
The problem- I keep getting the wrong number then the number I calculate when do it manually.
Can someone please advice?
Thanks!