Edited: I solved the first issue I mentioned. However I cannot figure out the issue regarding the formula {750mL}*13
Suspected Bug in Formulas (Simple Addition and Multiplication Formulas)
+27Which 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?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.