Search fields, Create Flag

[Anonymous]

Hi

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?

Dimension:

CustomerRef,

JobRef

Expression:

Lapse_A

Lapse_B

Lapse_C

Lapse_D

Lapse_E

If any of the Lapse fields in my table contain '999', then flag for the customer ref

Any thoughts?

Cheers

Phil

[m_woolf · Accepted solution]

=if(Lapse_A='999' or Lapse_B='999' or

     Lapse_C='999' or Lapse_D='999' or Lapse_E='999',

          1,0) as Flag,

[Anil_Babu_Samineni]

Or This?

=if(Lapse_A='999', If(Lapse_B='999', If(Lapse_C='999', If(Lapse_D='999', If(Lapse_E='999',1,0))))) as Flag,

[el_aprendiz111]

Hi,

IF(RangeSum(Lapse_A,Lapse_B,Lapse_C,Lapse_D,Lapse_E)=999*5,1,0) AS FLAG;

[Anonymous]

Sorted.  I thought there might be an easier way.  Cheers   Phil