5 Replies Latest reply: Jul 2, 2014 8:02 AM by Piet Hein van der Stigchel RSS

    how to list all if()s in one columm

      Hi, I just get AmountALL, and the other wont show up,

      if I delete AmountALL, the other shows up...

      Are there rules of ordering this Ifs ?

      My intention is to have a LIST with all of that IF()s as ZGr..

      Whats wrong?

       

      Here my script..

       

      Load

          If(  ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400','T83500'),'AmountALL',

          If(  ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83500'), 'Direct',

          If(  ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400'), 'Other',

          If(  ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400','T83500') and  Match("Global Dimension 2 Code",'DE702100024','DE702100025','DE702100026'),'Service' ,

          If(  ("G_L Account No_"<=479999 and "G_L Account No_">=400000) and Match("Global Dimension 1 Code",'T83400','T83500') and   WildMatch("Global Dimension 2 Code",'DE7011*'),'Project'

           ))))) as ZGr

      ;