Total Float Issues
Hello,
I'm having trouble getting the hang of the totalfloat() function.
For one thing, many of my tasks are returning with a negative total float value. It seems to be related to the start-to-finish function, but I don't know how to interpret this, or if it's just nonsense data:
Additionally, there are many cases where when a task is one day from being critical path, its float is not 1, but something crazy like -58 days from being critical path. Then when it becomes critical path, it shoots down to zero, and the original critical path jumps to some other large negative number.
Any insight would be appreciated.
Ian
Answers
-
Hi @Ian Ix
TOTALFLOAT is a fairly new function so I'm not actually sure what the intended functionality is when used with custom Predecessor links.
I can replicate what you're seeing with SF predecessors: it sees the time from when the current task ends to when the Predecessor task ends as negative float time, even though it's not. I would recommend contacting Support so that they can investigate and confirm the intended behaviour of this function. It would be helpful for them to see full screen captures of you sheet with the Predecessor column fully showing and row numbers so they can replicate this, too.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Theres a good chance you are using lag, and that is messing up the float calculations ;) Eliminate lag with creative tasks and you should be good to go! Hope this helps.
-
Hi @Ian Ix - were you ever able to resolve this issue? I'm seeing something similar. I've eliminated any use of SF, FF, and SS predecessors in the path, yet still seem to be having issues.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!