5 Replies Latest reply: Sep 12, 2016 11:14 PM by PAUL YEO RSS

    How to compute aging report only display >180 days amount ?

    PAUL YEO

      Hi All

       

       

      I have Table 1 using below expression from sunny working fine :-

       

       

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

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

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

      If(aging >= 91 and aging <= 120, Dual('91-120', 4),

      If(aging >= 121 and aging <= 150, Dual('121-150', 5),

      If(aging >= 151 and aging <= 180, Dual('151-180', 6), Dual('>181', 7)))))))

       

      Now i only want to filter company debt only > 180 Days , i try to modify the above expression to below :-

       

      = If(aging >= 151 and aging <= 180, Dual('151-180', 6), Dual('Only >181', 7))

       

      But it display the total amount at Table 2 ,I need table 2 display 22,559

       

      Can some one advise me.

       

      Paul