CR9 How to do with If statement?

[JoyCR9]

If may not be the tool I want to use, so please advise accordingly.

Problem:

I have two formulas entered in the detail section of my report. Both are time formulas formatted DD:HH:MM:SS. I want to compare formula 1 to formula 2 and print a text message.

eg:
if {@formula1} is less than or equal to {@formula2}
then "SLA MET"

I can't figure out how to get this to work.

sample data from formula 1:

00:00:25:38
00:00:45:43

sample data from formula 2:
00:01:00:00
00:04:00:00

 

[Turkbear]

If the 2 formulas return the same type value, then did you try a new formula like:

if {@formula1} <= {@formula2}
then "SLA MET"
else
"SLA NOT MET"

Place that formula on your report..

 

[JoyCR9]

Embarrassed...tried that prior to posting...didn't work.

Does now. Must have had a typo in it.

Thanks