Skip to Content
Former Member
Sep 10, 2008 at 06:25 PM

Count SLA misses and restart time when it hits the threshold


I have 3 fields that need to be evaluated in this formula.

1. file name

2. SLA

3. Time

So if a file fails the SLA 2 times then the time needs to reset to 15 months else I need a counter that counts down the days from the last SLA miss starting with 15 months.

SLA is a formula that says if time is >15:01 then "Miss" else "Pass"

Can anyone help me?