What do you mean by format? Do you simply want a currency identifier at the front?
Do you also need to swap currencies values?
Are all your Sales in a single column with a separate Country field for identification?
this would work but it has multiple issues...
IF [Country / Region] = "United States of America" THEN '$'+ STR([Sales]) ELSE NULL END
you would have to predefine every country/ currency & the sales is left a string (which is no good for calculations)
A better way maybe to create a separate Currency field (possibly at the data source) then have it as a separate dimension/ field, could be placed by the side, used for filtering etc.
If [Country] = "Ind" then "Rs. " + str([Sales])
elseif [Country] = "USA" then "$ " + str([Sales])
elseif [Country] = "UK" then "# " + str([Sales])
I had mentioned that above, i think the problems with this method are -
You have to predefine every country & currency combination (and keep it up-to-date!)
Also, Sales is then output as a string which is no good for calculations such as sum.
I had though a potentially better way would be to define a separate currency field, then the Sales & Currency columns could be reported side by side, visually it could look OK but crucially you can continue using Sales as a measure.
What do you think?
Hi MArk Fraser,
I got an idea, If we have option of mapping a Calculated field to Prefix option in the Default properties, it will help us a lot, am i right?
Yes, you are right keeping Symbol, Measure in two different fields.
Yes, I think something like that...
I'm particularly interested as we operate globally.
In the near future I need to worry about currency types and conversion. Ideally I want a way to manage 'global' content in a single report... predefine individual currencies, rates etc
I'd like to work smarter than just duplicate, duplicate and duplicate...
Will search the ideas...
My point is not to display the currency code only but like this..
Say i have taken data in map format with Region and sales.
Defaultly sales should be in $ format. But if click on any country it should show in that country's format.
Say If i click on India, only India region will highlight rgt, in that sales also should show in India's currency format. Like this it should happen for all the selections.
Did you find any solution for this, I am facing same problem.