Hi,

I have the following formula:

if {PROBSUMMARYM1.FIX_TIME}>={PROBSUMMARYM1.TARGET_FIX_TIME} then 1 else 0

This sets it to 1 if it takes longer to fix than it should.  I now want to report whether the fix was 0-5 days later, 6-10 days late and so on. How would I do this?

Thanks

Christine

If I am not mistaking, if you substract one date from another in CR, the result will be number of days... something like

if {PROBSUMMARYM1.FIX_TIME}-{PROBSUMMARYM1.TARGET_FIX_TIME}>5 then 1 else 0


____________________________
If you find the answer helpful, please mark this topic as solved.