Currency number formatting

[CVR]

Hi,

I would like to know if there is any chance in QV to format the currency number on dashboard for different countries by selecting the country in the drop down or any kind of selection.

Eg: When I select USA in the drop down then I should see the currency value 100.00  ( Dot after 100)

       If I select Mexico in the drop down then I should see the currency value 100,00 (Comma after 100)

FYI Both the values are same just the comma and dot should be different

Thanks in Advance.

[Anil_Babu_Samineni]

There is nothing formula for that? You may use If..Else condition or Pick(Match()) only

Pick(Match(Country, 'USA','Mexico'), Num(Sum({<Country = {'USA'}>} Sales), '#,##0'), Num(Sum({<Country = {'Mexico'}>} Sales), '#.##0'))

[CVR]

Thanks for your reply!

I have almost 15 countries in my list and there are 10 different fields and one among them is currency. Will the above script works with this scenario?

Thanks in Advance