Suspected Bug in Formulas (Simple Addition and Multiplication Formulas)

[Kelsey_Freeman1]

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

[Kamille_Parks]

Kelsey_Freeman1:

You can see in the screenshot that some of the total gallons are correct where others are not.

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}?

[Kelsey_Freeman1]

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

[Bill_French]

Kelsey_Freeman1:

some of the total gallons are correct where others are not.

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