Hello,
My users have different location settings (probably variants between Dutch, UK and US) and this results into some mixed output and display issues within my application.
In the app, there's a gallery where they can enter certain values, e.g. volume and price, to calculate the price per volume, I have the following code:
If(
!IsBlank(I_Volume),
(I_Price / (I_Volume / 1000)),
I_Price.Text
)
The only issue is that with different location settings, the output is sometimes with a comma decimal separator and sometimes with a dot. Having different types of output is an issue for other systems to pick up the information; it needs to be one or the other.
Furthermore, when someone with the US setting makes a calculation like 500 / 18.5, it is displayed in a gallery as a rounded 27.03, for example. To them it looks lovely, the calculation is through, nothing wrong.
However, when someone with the Dutch region settings has a look at their upload, they are looking at a 27027027027027.... They might think there is some sort of input error or there has been a massive inflation.
Does anyone know how I can therefore 1) force the comma separator in the calculations and 2) force readers the same format, so US users will also see 27,03? Help would be much appreciated.
