4 Replies Latest reply: Oct 3, 2016 3:20 PM by Vivek Nair RSS

    WILMATCH AND PICK

    NITESH KUMAR

      I have two fields containing these values :




      Header 1Header 2
      "JU | PLAN"1
      "JU | ACTUAL"2
      "FBP | PLAN"3
      " FBP | ACTUAL"4
      "LRFP | PLAN" 5
      " NU | ACTUAL"6



      I want to aggregate(sum) JU together and FBP together and  "ACTUAL" together

      the result should come like this : JU - 3 , FBP - 7 , ACTUAL - 12

       

       

      PLEASE check the below code :



      IF(wildmatch(SNAP_Type_LE_BREAKUP,('JU |*') ,('FBP |*'),'*ACTUAL'),

      PICK(wildmatch(SNAP_Type_LE_BREAKUP,'JU |*','FBP*','*ACTUAL')

      ,'JU','FBP','ACTUAL'))

       

       

      this code is giving correct result for JU and FBP but FOR ACTUAL IT IS CONSIDERING  ONLY NU | ACTUAL FOR SUM"