7 Replies Latest reply: Jul 28, 2016 2:45 AM by PAUL YEO RSS

    How to make S$40141.77 display as S$40,141.77 ?

    PAUL YEO

      Hi All

       

       

      I have expression from Mr Ram :-

       

       

      'S$ ' & 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')

       

       

      I like to know how to make S$40141.77 display as S$40,141.77 ? i need a comma between 0 and 1 .

       

       

       

       

       

       

      Paul