4 Replies Latest reply: Apr 6, 2017 9:09 AM by Phil Speight RSS

    Search fields, Create Flag

    Phil Speight

      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