- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 12, 2022 05:40 PM
Edited: I solved the first issue I mentioned. However I cannot figure out the issue regarding the formula {750mL}*13
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 12, 2022 05:50 PM
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}
?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 12, 2022 05:57 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 13, 2022 05:35 PM
I’ll bet three jelly doughnuts it’s the floating point bug maybe?