6 Replies Latest reply: Aug 24, 2018 3:46 PM by Emma Morales RSS

    Nested IF as Dimension

    Ashley Kuttler

      Hello,

       

      I have the following Dimension:

       

      =IF(WildMatch ([LINE_ITEM_ADJUSTMENTS], '*CO-107*',

      ), 'Registration Error')

       

      Can I write this expression to include multiple if wild match conditions?

       

      Such as:

       

      =IF(WildMatch([LINE_ITEM_ADJUSTMENTS], '*CO-107*','Registration Error'),

      IF(WildMatch([LINE_ITEM_ADJUSTMENTS], '*CO-24^*', 'Captation')))

       

      Thanks in advance.