You’re offline. This is a read only version of the page.
Announcements
Two users of the report, from Germany and US use the same app created by a US developer. No error when a US user use the app but when the German user use the app, the fields are calculated by 1000.
On the US user app:
Text_Input_A: 5
Text_Input_B: 6
Label_Answer_C: 30,000.00
On the German user app:
Text_Input_A: 5
Text_Input_B:
6 Label_Answer_C: 30.000,00
Text_Input_A is on Screen 1, Format is Text
Text_Input B is on Screen 2, Format is Text
Label_Answer_C is on Screen 1, Formula is Text(Text_Input_A * Text_Input_B, "[$-en-US]#,###.00")
Thanks in advance for helping me on this
Hi @katsquinx :
Firstly,let me explain why you encounted this problem.
In Germany, the functions of "," and "." in digital expression are completely opposite.
"." is a three-digit separator above the ones place, and "," is used to separate the ones place and the decimal point.
I think these links will help you a lot:
Formula separators and chaining operator
Secondly,If you want the numbers in the label to be displayed in English habit, please use the following formula:
Share
Report
All responses (
Answers (
Text(Text_Input_A * Text_Input_B, "[$-en-US]#,###.00","en")I think this link will help you a lot:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text
Best Regards,
Bof
765
