Getting Inconsistent and unreliable total float values that do not make sense.
Whilst working on a specific project, we experienced several dissimilarirteis in Total Float in Gannt View and Grid view.
I have highlighted Row#10, Row#17, and Row#19.
If you look at Row#10 under Gant view we have 11 days of total float. however, in the grid view it shows 0.
In Row 17, it shows 2 days of float in the grid view but in gantt view, we can see that we have 16 days of total float.
In Row 19, grid view shows 2 days of float but in reality we only have 1 as you can see in the gantt chart.
We are also getting -1 float for Row 29 and Row 31.
The formula we have been using is - TOTALFLOAT([Task Name]@row)
Any leads are appreciated. Thank you.
Help Article Resources
Check out the Formula Handbook template!