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