Write decimal numbers with 2 digits after the coma

[Sara_Bertomeu]

Hello a new doubt, how can I write decimal numbers with 2 digits after the coma

I have to write decimal numbers like 00,00 € (two decimals)

In excel I used DECIMAL([IMPORTE IVA]/[Cantidad];2)

But in Appsheet, I can't write this. 

I read the help data, and found : 

I do it with : DECIMAL([IMPORTE IVA]/[Cantidad]) 

, that it's ok,but in the backend, it shows 4 digits. 

And I try the other way: [IMPORTE IVA]/[Cantidad]

and it shows the correct data that I need (2 digits),

 

but if I modify it shows

and I have to rounded each time.

There is some tip?  thanks

[Rafael_ANEIC-PY · Accepted solution]

Hello @Sara_Bertomeu, for the case of app formulas, if you set that column's decimal places to 2 it should display the number in the way you want.

If you want to limit the decimals on a column that requires or allows user input and don't want to be bothered having to manually manage the decimals, you can allow a large amount of decimals in that column (like 5 decimals) and then use another column to round that value to the decimal places of your preference.

OR you can use this expression in an event action so that it modifies your value after saving the form to 2 decimals:

ROUND( [Decimal] * 100) / 100.0

[Sara_Bertomeu]

Guauuu, great idea, thanks I'm going to try. Thanks a lot