Does appsheet not handle ROUND() in a VC TEXT column?

[KON_TROLL]

Looks like AppSheet cannot calculate (ROUND((( [Inntekt poster] - [Kostnad poster] ) / [Inntekt poster])*10000) / 100) correctly. Before saving, it looks right in preview, but after it changes. This should show 2 decimals, but after save it calculates as FLOOR() with NO decimals. Try it your selves…
…and preview before save shows correct format according to language settings for the table, but after saving it turns into english… Buggy

[Steve]

Long-standing, well-known behavior. Don’t mix Integer and Decimal values.

Fix for expression giving 0% or missing decimal part

Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…

[KON_TROLL]

Thanks, Steve. That did it regarding decimals. (ROUND(( [Inntekt poster] - [Kostnad poster] ) / ([Inntekt poster])*10000.0) / 100.0) works fine.
But any idea about the format issue. I’ll paste here. As you see the two first amounts has Norwegian format, but the TEXT calculated gives English format.

[Steve]

I’m afraid I don’t know.