Forum Discussion
Help With Custom Field to Calculate Duration Variance
I'm trying to create a custom duration variance field instead of the built in Duration variance field as the built-in duration variance uses Duration - Baseline Duration and Duration is based on a "P...
JBLT-77 I think I solved for the formula syntax error because I got this formula to work:
IIf([% Complete]=100,round([Baseline Duration]-[Elapsed Duration]),IIf([% Complete] Between 0 And 100,round([Actual Duration]-[Elapsed Duration]),0))
So this should mean:
- A positive variance indicates ahead of schedule.
- A 0 variance indicates on schedule
- Negative variance indicates behind schedule