5 Replies Latest reply on Feb 22, 2018 3:50 PM by andrew borunda

    Adding a Condition Formula to a Data source Extract Filter

    katie worthen

      I need to limit my dataset to only 'External' orders for most accounts.  For a few specific accounts I need to allow both 'External' and 'Internal' orders.

      In the Extract Data pane I have been trying to add a 'Condition' 'By Formula' similar to this:

       

      IF [Global Acct Name (Dw Sbl Account D)]='ABC'

      OR [Global Acct Name (Dw Sbl Account D)]='DEF'

      OR [Global Acct Name (Dw Sbl Account D)]='GHI'

      OR [Global Acct Name (Dw Sbl Account D)]='JKL'

      OR [Global Acct Name (Dw Sbl Account D)]='MNO'

      OR [Global Acct Name (Dw Sbl Account D)]='PQR'

      THEN [Int Ext] IN 'Internal','External'

      ELSE [Int Ext]IN 'External'

      END

       

      All I get are errors.  Any clues on the correct syntax would be welcome.