Forum Discussion

nicolast29's avatar
nicolast29
Helper V
2 years ago

problem with foating number

Hi I have to transert data to a SAAS financial software This one contrôle day by day the total between 2 column who must be equal to zéro   For me due to the storage of the values with foating va...
Need Help
nicolast29's avatar
nicolast29
Helper V
2 years ago

thanks for replying, but it doesn't help, because i need to import each row, not the group by

Ands if you look at the result of your request i have the same problem

 

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    2 years ago

    Well then you can use the pivot table added field formulas I provided to round or check for significant differences.

     

    And since you seem to think that a difference of 0.01 is NOT significant, adjust the formulas to what you think is significant.

     

    But note that the differences of 0.01 are real based on your original table in your workbook -- they are not a result of floating point inaccuracies. You'd need to go further back in the data chain to determine where that 0.01 difference is coming from.