11 Replies Latest reply on Nov 2, 2016 5:15 PM by Ivan Young

    Truncating instead of rounding a number

    Federico Armentano

      Hi, I would like to truncate a number to the first two decimals. For example, 10.8299 it would be 10.82.


      In excel I would do TRUNC(10.8299)= 10.82.


      ROUND FUNCTIONS is not an option because TRUNC(10.8299)= 10.83.


      The filed "value" have positive a negative numbers


      I would appreciate some help,


      Thanks a lot!