How do I handle complex calculations?

[karimoo]

You can try if using Adalo on top of Airtable and with this, the existing Formula may work for you.
See: Airtable - Adalo Resources
Note that there are certain restrictions with the Airtable API such as Maximum Number of records you can read from the database: 100.

You can try to create the formulas in Adalo using Custom Formula.
See How to Create a Custom Math Formula - Adalo Resources

What I learned today working on this

Help : How to keep only last 2 digits ? 7408."83"

I am not exactly sure, where you want to have the rounding. But you can use a combination of INT() and ROUND() with scaling factors inside and outside the functions to cut where you need it: [image] [image] or [image] You can play with the scaling factors in my test app here:

is that there are some restrictions in combining functions. E.g. a Round(Round(##)) did not work for me.