11 Replies Latest reply: May 14, 2014 3:55 AM by Tresesco B RSS

    match function in Add calculated dimension

    Narender Makhija

      Hi All,

      I am using match function in straight table(in add calculated dimention).But my match function is not properly working as per my condition.

       

      Straight table dimention>add calculated dimetion

       

      =if(CPC_CODE='C473','XYZ',

      if(CPC_CODE='C430','pqr',

      if(match(CPC_CODE,'C4241'),'A',

      if(match(CPC_CODE,'C423'),'B',

      if(match(CPC_CODE,'C4301','C4302'),'C',

      if(match(CPC_CODE,'C4301','C473','C4302','C430','C473'),'D'

      ))))))

       

      Result is showing

      XYZ

      pqr

      A

      B

      C

       

      but not showing D.I  want to show all condition.

       

      Because in match function for D : CPC_CODE =4310 and 4302 is repeating as we have used CPC_CODE =4310 and 4302 in match function for C.So Match function is not working where CPC_CODE already used in other case.Pls tell what i have to do.Or there is any other function to solve this??