Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Suspected Bug in Formulas (Simple Addition and Multiplication Formulas)

Topic Labels: Formulas
408 3
Showing results for 
Search instead for 
Did you mean: 

Edited: I solved the first issue I mentioned. However I cannot figure out the issue regarding the formula {750mL}*13

Screen Shot 2022-01-12 at 5.39.05 PM

3 Replies 3

Which ones are incorrect? I added all those into a calculator and every one returned the same number as your formula field.

What is the formula for the field {750mL}?

I get the following discrepancies:

  • 2055*13 = 26,715 vs 26,721
  • 419*13 = 5447 vs 5449
    18013 = 2340 vs 2343

The 750mL formula is Estimated Gallons / 2.38

I’ll bet three jelly doughnuts it’s the floating point bug maybe?