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!