5 Replies Latest reply: Aug 2, 2017 8:17 PM by PAUL YEO RSS

    Where go wrong with this expression ? sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar)) , it display null.

    PAUL YEO

      sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))

      Hi All

       

       

      I have a Pivot table 1 , which is working fine, i like to convert it to straight table.

       

       

      Dimension :-

       

       

      COMPANY_PAY

       

       

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

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

      If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

      If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4), Dual('>121 ', 5)))))

       

      Expresion :-

       

      Sum(total_ar)

       

       

      I like to convert it into straight table. Hope some one can advise me.

       

       

      I try on Table 2 it display null :-

       

       

      Dimension :-

       

       

      COMPANY_PAY

       

       

      Expresion :-

       

      sum(If(aging_ar >= 1 and aging_ar <= 30),total_ar))

       

      The error is above expression.

       

      Pauk Yeo