4 Replies Latest reply: Jul 28, 2016 3:58 AM by PAUL YEO RSS

    Straight table sum up 4 row data , how to make it display 159,141 ?

    PAUL YEO

      Hi All

       

       

      I got the below expression from Ram :-

       

       

      'S$ ' & Num(If ( US_Cust='USD', 1.3,if(US_Cust='EU',1.5, 1)) *Num(

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

      ,'###,##0.00'),'###,##0')

       

       

      But when it sum up the 4 row of data , it display S$ 118,299 , which is wrong , How to make it display 159,141 ?

       

       

      Paul