9 Replies Latest reply on May 18, 2016 4:48 PM by Ashish Chaudhari

    Round function not working correctly with Excel data

    Dave Ricketts

      I am having trouble with the Round function working correctly.  Source data is Excel.  Two examples below:


      Data In:   .893   (in Excel with 10 decimals, value is 0.8930000000)

      Function:    Str(Round([Data In], 2) )

      Result:   .8929

       

      Data In:   1.6     (in Excel with 20 decimals, value is 1.60000000000000000000)

      Function:    Str(Round([Data In], 2) )

      Result:   1.6000000000000001

       

      Is this a bug, or am I doing something wrong?