3 Replies Latest reply: Jun 8, 2016 6:37 AM by PAUL YEO RSS

    How to filter Table only display those Row Debt more then sales ?

    PAUL YEO

      Hi All

       

       

      I have a table display debt and sales.

       

       

      I want to only filter when debt is more then sales.

       

       

      Diamension :-

       

       

      =company

       

       

      Expression :-

       

       

      (sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/1000

       

       

      sum(if(L5M='-1',sales/1000))

       

       

      I have try below expression :-

       

       

      =If

      (

       

       

      (

      sum(if(L5M='-1',sales/1000))

      )

      >

      (

      (sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/1000

      )

       

       

      ,company)

       

       

       

       

       

       

      it does not work

       

       

      Paul