0 Replies Latest reply on Jun 5, 2019 11:17 PM by Nupur Rawat

    Truncate decimal value in DT tool

    Nupur Rawat New Member

      Hi All,

      I am new to the DT tool and recently facing an issue with decimal precision when calculating.


      I have a calculation in place to sum up the decimal values for a column for each recurring instance. For a certain amount the resultant value adds a few zeros after the original value.

      For example,

      12.11 + 10.11= 22.22

      But the tool calculates it as 22.22000001


      I had read in one of the threads to round up the values using function


      Which actually works but I am dealing with financial data and can't afford to round up the values.


      Please suggest how I can truncate or probably round down in the tool to two decimal place.