4 Replies Latest reply: May 5, 2017 3:16 AM by Rahul Pawar RSS

    How to convert dimension expression to load script expression ?

    Yeo Poh sai

      Hi All

       

       

      I have field name = aging_ar

       

       

      This field have number from 1 to 360

       

       

      I like to create a new filed name = aging_ar_class

       

       

      which is

       

       

      1=1-30

      2=31-60

      3=61-90

       

       

      In chart dimension expression below working fine :-  

      =If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

      If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2), Dual('>61', 3)))

       

      I have try convert the above expression to below for load script expression  :-

       

      If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

      If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2), Dual('>61', 3))) as aging_ar_class,

       

      it does not work , Hope some one can advise me.

       

       

      Paul