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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.