I am trying to make a simple multiplication in my app.
This is the format I want it to be
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?
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:
And then if you want the output to always be displayed in Spanish:
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.
In the multiplication if I use "," as a decimal separator I get wrong total.
If I use "." as a decimal separator I get this
Slight error in my previous post: use
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.