2 Replies Latest reply on Jun 7, 2019 2:23 AM by Nupur Rawat

    Truncate decimal values 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.

      Issue:

      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

      round(100*parseFloat($1))/100

      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.