Format amount as british pounds

Question

Is it possible to format a display string as pritish pounds instead of US dollars?  I have transactions in both currencys and need to format each.

---

John Schroeder

Answer 1

You can use the Currency format on the measure and change the LANGUAGE property on a subcube to switch between USD and GBP as desired.

Check this post from Mosha for more guidance
http://sqlblog.com/blogs/mosha/archive/2005/10/13/formatting-currency-values-in-mdx.aspx

HTH

---

-Remember to mark as helpful/the answer if you agree with the post.

Answer 2

Using the Currency format and the Language property is a bit dangerous as the Language property also affects other things such as the symbol used as the decimal separator, as I argue here:

http://cwebbbi.wordpress.com/2008/04/24/currency-formats-should-they-be-tied-to-language/

I think it's better to use scoped assignments and the FORMAT_STRING property to do this.

Chris

---

Blog: http://cwebbbi.wordpress.com/ Consultancy: http://www.crossjoin.co.uk/