Skip to main content

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



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



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



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’ll bet three jelly doughnuts it’s the floating point bug maybe?


Reply