2 Replies Latest reply: Jul 5, 2013 5:36 AM by Vishwaranjan Kumar RSS

    Help with Set Analysis

    Priyanka Rao

      Hi,

      Need to get the ASSIGNMENT Values populated in a straight Table against a Dimension.The following conditions need to be applied:

      1. Customer= 'NA' or 'Exception'

               AND

      2. ASSIGNMENT=(starting from) 'C-' or 'c-'

              AND

      3. num(Customer)= mid(ASSIGNMENT,3)

       

      My Result : Which satisfies 1 & 2 conditions
      Only({($<VERTICAL={'NA','Exception'},ASSIGNMENT={'c-*','C-*'}>)}ASSIGNMENT)

       

       

      Need Help in Adding the 3rd Condition to the above SA...