on 09-10-2008 7:25 PM
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?
Test for nulls, if CR runs into one it stops processing the formula.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.