Hello,
I am trying to make a simple multiplication in my app.
This is the format I want it to be
Num1:2
Num2:23,00
Total:46,00
I want it to be like this: 1.234,00 euro
So I think this is the right formula : "[$-en-US] #,###.00", "es-ES"
I can use this in "Total" field but Num2 field has to be 23.00 not 23,00.
Any suggestions on what is going wrong?
Hi @StellaTs
I am not sure I understand the question fully, could you please clarify?
Are the first numbers being input into two text inputs and the third in a label?
Could you provide a screenshot?
Num1 is a Text Input.
Num2 and Total are Label.
The user can enter the quantity he wants in Num1.
In Num2 appears the price of an item.
If I understand correctl you want the nunbers to always be parsed in Spanish, regardless of the current locale. Try this:
Value(Num2.Text,"es-ES")*Value(Num1.Text,"es-ES")
And then if you want the output to always be displayed in Spanish:
Text(Value(Num2.Text,"es-ES")*Value(Num1.Text,"es-ES"),"#,##.00","es-ES")
By default numbers will be parsed and displayed in the current locale (which you can tell from the Language() function). From your description you want input and output in Spanish, but your current locale is not Spanish. The above formula forces both to be Spanish.
I want to use "." as a thousands separator and "," as a decimal separator.
e.g. 1.234,56
In the multiplication if I use "," as a decimal separator I get wrong total.
e.g.
Num1:2
Num2:12,00
Total:2.400,00
If I use "." as a decimal separator I get this
e.g.
Num1:2
Num2:12.00
Total:24,00
Slight error in my previous post: use
Text(Value(Num2.Text,"es-ES")*Value(Num1.Text,"es-ES"),"[$-en-US]#,##.00","es-ES")
as my format string was in American format, which works for me but not for you. Forcing the format string to American should make this work for you too.
I've already used that this is the result.
"," and "." appearing at the same time
Num1:2
Num2:23
Total:46.,00
Please post a screenshot of the formula you are using for Total
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
162 | |
91 | |
67 | |
63 | |
63 |
User | Count |
---|---|
216 | |
158 | |
96 | |
86 | |
79 |