I have a list of 5 fields which contain lapse times. These are loaded as part of the load script. My report has a table which averages the lapse times as an expression. I have created an error code 999 to identify some specific issues with the lapse times fields.
What I need to do is create a table which looks at any of the lapse times fields and shows a flag to identify if any of the fields have code 999.
Can anyone help me do this?
If any of the Lapse fields in my table contain '999', then flag for the customer ref