4 Replies Latest reply: Apr 1, 2014 10:22 AM by Chanel Choo RSS

    Rounded value (1.6 become 1.0)

      Dear Community,

       

      As we know, we can round the Million to 2 digits by :

      num(1600000/1000000 , '#,#') =  1.6

      or

      num(1600000/1000000 , '#,0') = 2.0

       

      Any method or function that can make this to 1.0 ?

      For example:

      xxx(1600000/1000000, 'xxx') = 1.0

      or

      xxx(1600000, 'xxx') = 1000000

       

       

       

      Thanks and best regards,

      Chanel