Decimal precision

You can now configure decimal precision on your Noloco Collection and Google Sheet fields from the data tab. It’ll default to two decimal places but you can go wild and choose from 1 to 8 decimal places (you crazy like that). We also now sync the decimal precision set on Airtable fields and respect this in Noloco automatically.

1 Like

any way to get it to display 25% and not 25.0%

1 Like

Not at the moment @rjp - you could possibly use a formula field if you want more granularity when displaying your percentage

I’m experienced an issue with this. I have a formula field in AirTable that is calculating a number correctly to be 1.6. When I change the decimal precision in AirTable to zero, AirTable correctly rounds the number up to 2 which is what I want. However, Noloco is rounding the number down to 1. Is this expected behavior or is this a bug?

What sort of field is it @bhosey ?

We know that Airtable round when we do truncation so I think that might be the problem…

Eg a number in Airtable might be:
400.267920

Limiting that to 2 decimal places I think they arrive at 400.27 whereas in Noloco we make it 400.26

For what it’s worth, in calculations, we still use the same underlying values, the rounding/truncating is just done on the display level

If you can share an example we can look into it