Case (LifeRemaining < 0; 0; LifeRemaining > 0 AND LifeRemaining < 5 ; 1; LifeRemaining > 5; 2)
Sort it on that calculation field to group your records into the three groups you need. You can use any values you want instead of 0, 1, 2 as long as the values sort into the order you want in your report.
something along this line may work:
Life Remaining ≤ 1 ; 1 ;
Life Remaining ≤ 5 ; 2 ;
Your calculation format worked great, thank you so much!! I knew what I needed, but not how to express it in a function.
Now, there's one more aspect that I've discovered I need to add to the calculation.
I need to exclude certain records from the list based on what it says in a certain field. Specifically, there is a field called "System State" and when it says "New", I don't want those records included in the list. How do I do this? Would I accomplish this by adding something to the Life Remaining Calculation, since it sorts the information, saying (in my layman terms) "When System State = New, do not include"? Or is there another way?
Thanks in advance for your help!
Buon Giorno, Daniele! I had a reply from another forum member, but your idea was similar, so grazie!
Parlo un po'italiano, ma il vostro inglese e molto meglio :)
If you want the record to be omitted from your report, omit it from the found set:
Enter find mode
Enter "New" in the System State field.
Select the "omit" option
Click Perform Find
Sort your records.
In a script, you can add the Perform Find script step and click the Specify button to set this up.