cancel
Showing results for 
Search instead for 
Did you mean: 

Count SLA misses and restart time when it hits the threshold

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Test for nulls, if CR runs into one it stops processing the formula.

Former Member
0 Kudos

This is where I am stuck:

If {@Availabilty} in "Miss" and count({@Availabilty})>=2

then

datediff("d",Date (2008,08 ,20),Date(2009,11,20))

I dont know how to get to to count down if there are no more misses. or reset if there are 2 more misses per file

Former Member
0 Kudos

This would be a perfect problem to solve using manual running totals. Check out the following article.

It's not really clear what is a field and what is formula in your sample data set. If you can clarify, might be able to help.. Otherwise, if you have the time, spend an hour understanding how to create and use manual running totals and you'll absolutely fix this issue...

https://boc.sdn.sap.com/node/19837

Will

Former Member
0 Kudos

I have a date field and for each date we have a file name field that matches up to it. Then I have a formula:

If {Files.Processing End Time}> CDateTime (1899, 12, 30, 15, 01, 00)

then

"Miss"

else

"Pass"

So I have the report group by Files.File Name and the I display

Files.File Date and the above formula.

If any one of the files has 2 "miss" in one month I need to restart the day count down (which I dont have yet).

So I need a column that displays the days left until the sla restarts. It restarts everytime one of the files hasd 2 misses in one moth otherwise it continues to count down to the 15 month mark. Any better?