+5I’m having an issue with a formula that rounds up incorrectly, i’ve browsed the forums and can’t seem to find a solution.
I have a simple math equation x * y = z
I suspect that the issues is stemming from a formula that contains four decimal points:
I’m not able to round up this number, however, it needs to remain as is. I’m not sure how to get a correct calculation using airtable.
+32Hm, doing 68.52 * 5 gives me 342.6 while the screenshot shows 342.55, which makes me think that the field that shows ‘68.52’ is rounding it up as a display thing but actually has more decimal places. Could you edit the field with 68.52 to make it show up to 4 decimal places, and then multiply that number by 5 to see whether you get 342.55?
If that doesn’t work, could you provide screenshots / details of how the value of 68.52 is constructed with reference to ‘0.0134’?
+29Hey
As Adam mentioned above, you might want to provide further screenshots. I don’t think I’m fully following.
Anyway, you might want to look into Airtable’s Round formula expression in the meantime! See screenshot below.
+22Just to add on to
This is likely due to floating point precision. Try using ROUND() before ROUNDUP(), or only round the final result. If you can share your exact formula and an example, the community can help identify the issue quickly.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
