info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Finish variance formula
13 views
Skip to first unread message
X Toa
Jan 17, 2021, 5:46:59 PM1/17/21
to
Would anyone be able to troubleshoot the formula I have written to track finish variance in stoplights. It is not working. The logic is as follows:
If (task) = 100% complete, then black stoplight.
If (Finish Variance) ≤ 0, then green stoplight.
If (Finish Variance) > 0 AND < 5, then amber stoplight.
If (Finish Variance) > 5, then red stoplight.
1 = Green
2 = Amber
3 = Red
4 = Black
Switch([% Complete]=100,"4",[Finish Variance]≤0,"1",[Finish Variance]>0 And [Finish Variance]<5,"2",[Finish Variance]>5,"3")
Thanks.
If (task) = 100% complete, then black stoplight.
If (Finish Variance) ≤ 0, then green stoplight.
If (Finish Variance) > 0 AND < 5, then amber stoplight.
If (Finish Variance) > 5, then red stoplight.
1 = Green
2 = Amber
3 = Red
4 = Black
Switch([% Complete]=100,"4",[Finish Variance]≤0,"1",[Finish Variance]>0 And [Finish Variance]<5,"2",[Finish Variance]>5,"3")
Thanks.
0 new messages