cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StellaTs
Frequent Visitor

Currency format multiplication

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?

8 REPLIES 8
Meneghino
Community Champion
Community Champion

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,848)