0

Wrong result of multiplication

What could be the reason if I am trying to make a simple multiplication 415 * 1.305 the result is 541.5749999999999 instead of 541,575? What's wrong with the math? 

3 replies

null
    • szormpas
    • 6 mths ago
    • Reported - view

    Hi   welcome to Ninox community!

    You can use the round function:

    round(number, digits) To round a given number with the given number of digits.

    In your case, round (415 * 1.305, 3)

    • Timur_Aliiev
    • 6 mths ago
    • Reported - view

    , thanks a lot! 

    I have done a little bit other way (415 * (1.305*100))/100. It was easier in my case coz I need to round to 2 digits and with 541.5749999999999 the rounding was incorrect. But still it seems like a bug or I am missing smth?  

      • bink_inkel
      • 6 mths ago
      • Reported - view

       Setting the decimal places in 

      Edit fields >styles >Number format to 3 places or 4 places worked for me

Login to reply

Content aside

  • 6 mths agoLast active
  • 3Replies
  • 68Views
  • 3 Following