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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

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.

Users online (1,546)