Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Search fields, Create Flag

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

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

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

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

          1,0) as Flag,

View solution in original post

4 Replies
m_woolf
Master II
Master II

=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,

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
el_aprendiz111
Specialist
Specialist

Hi,

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

Anonymous
Not applicable
Author

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