5 Replies Latest reply: Oct 26, 2016 4:15 PM by Frank Hartmann RSS

    How to hide my table row with zero value ?

    Yeo Poh sai

      Hi All,

       

      I have a table , i am unable to remove those row with zero value. Hope some one can help me.

       

      Diamension :-

       

       

      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),

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

      If(aging_ar >= 151 and aging_ar <= 180, Dual('151-180', 6),

      If(aging_ar >= 181 and aging_ar <= 210, Dual('181-210', 7),

      If(aging_ar >= 211 and aging_ar <= 240, Dual('211-240', 8),

      If(aging_ar >= 241 and aging_ar <= 270, Dual('241-270', 9),

      If(aging_ar >= 271 and aging_ar <= 300, Dual('271-300', 10),

      If(aging_ar >= 301 and aging_ar <= 330, Dual('301-330', 11),

      If(aging_ar >= 331 and aging_ar <= 360, Dual('331-360', 12),

      If(aging_ar >= 361 and aging_ar <= 390, Dual('41-270', 13), Dual('>12 Mth', 14))))))))))))))

       

       

      Expression :-

      Sum(total_ar)

       

       

       

       

      Paul.