SSAS – Using the Euro or Pound currency Symbol in a measure Format String

If you have a set of measures and some of them are US dollars, some are Euros, and some are UK Pounds, you want to format them correctly in SSAS.

First you will need to know the ASCII command to type a pound and euro symbol. You can find this in the character map in windows. You must use the 10 key number pad to type these in while holding down ALT.

Euro = Alt + 0128 €

Pound = Alt + 0163 £

Next you will need to put a back slash in the format string before the symbol for it to show up in excel.

Here are the images from SSAS:

clip_image001

\£ #,##0.00;(\£ #,##0.00)

clip_image002

#,##0.00 \€;(#,##0.00 \€)

Here is the image from Excel:

clip_image003

Advertisements
This entry was posted in SSAS, Syndication and tagged . Bookmark the permalink.

One Response to SSAS – Using the Euro or Pound currency Symbol in a measure Format String

  1. Mark Johns says:

    Awesome thank you! Been pulling my hair out on this one!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s