How to fix the number to 2 decimal points

hi all. how can i fix the number to 2 decimal points. for example 10.70

everytime i want to to set to 10.70 , the system will store as 10.7

the only time i can make it 10.70 is when i set it to currency format.

can anyone help me with this?

I tried INT( x100)/100 and ABS( x 100)/100 but it still shows 10.7

any can help me please?

Hi @kalskee,

Unfortunately, number formatting built in Adalo doesn’t allow such capability.
Possible workaround could be to split the number into two - integer and fraction, and display them separately. I know it’s not the best solution (especially it requires additional property in a collection and some operations).

Best regards, Victor.

do you mind giving me the formula example to split them.

Hi @kalskee,

Let’s call the variables: TOTAL (the number itself), INTEGER (integer part) and FRACTION (fractional part).

INTEGER = INT (TOTAL)

FRACTION = INT ( ( TOTAL - INT (TOTAL) ) * 100 )

With this you get, let’s take the number 123,45678:

INTEGER = INT (123,45678) = 123

FRACTION = INT ( ( 123,45678 - INT (123,45678) ) * 100 ) = INT ( ( 123,45678 - 123 ) * 100 ) = INT ( 0, 45678 * 100) = 45.

Of course need to check this in the app )))

Best,
Victor.

tq for the response! you’re the best

1 Like