Project Variance Formula Using Levels
I need help with a formula that calculates variance between actual durations and planned durations set at the start. We frequently need to reset the baseline throughout a 3-5 year project, and I would like a historical record of where we started and where we ended, without having to copy/paste current baselines before they are reset.
In the image below, the column with the formula is "Duration Variance" and it subtracts "Duration" from "Target Duration". If the task is Level 2, it takes that number and adds the previous row in the column for a total project variance. When the level changes from 2 to 1, it gives a blank cell, which is what I want.
The Problem: When the task goes back to being Level 2, it only gives a 0 instead of allowing me to select the previous level 2 task target duration.
Any help would be appreciated! Thank you!
Help Article Resources
Check out the Formula Handbook template!