Ask Search:
Max GMax G 

Change currency format in einstein analytics

Hi community,
I want to change the currency format of einstein analytics to the european format 999.999.999,99 €.

I found in the past the following article https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_xmd.meta/bi_dev_guide_xmd/bi_xmd_format_currency.htm

And I tried to build a format like in the article: "customFormat":"[\"€###.###.###,##\",1]"
but einstein display the values like this: User-added image

Could someone help me to change the format? Thanks!
Best Answer chosen by Max G
Akshay AhujaAkshay Ahuja
Hello,

Now you can change the format for Measures from the dataset itself. Follow the steps below:

1. Open the dataset as a lens. This is the dataset that you are using to create widgets on dashboard.
Open dataset as a lens
2. Click on Fields (as shown above) and search for the measure. You can also create a derived measure. Make sure that the name of the derived measure matches the name you are using for measure on Number widget. In this example, I'm adding a Euro symbol for Opportunity Amount.
Add Formatting

3. Select custom format and add the formatting as shown. Click Done. And then click Save.
Add Formatting 2

4. Now, when you create a Number widget/chart with Amount field, the € symbol should be present. Make sure to refresh the browser after you save the changes to the format.
Add Formatting 3
Hope this helps.

Best Regards,
Akshay

All Answers

Akshay AhujaAkshay Ahuja
Hello,

Now you can change the format for Measures from the dataset itself. Follow the steps below:

1. Open the dataset as a lens. This is the dataset that you are using to create widgets on dashboard.
Open dataset as a lens
2. Click on Fields (as shown above) and search for the measure. You can also create a derived measure. Make sure that the name of the derived measure matches the name you are using for measure on Number widget. In this example, I'm adding a Euro symbol for Opportunity Amount.
Add Formatting

3. Select custom format and add the formatting as shown. Click Done. And then click Save.
Add Formatting 2

4. Now, when you create a Number widget/chart with Amount field, the € symbol should be present. Make sure to refresh the browser after you save the changes to the format.
Add Formatting 3
Hope this helps.

Best Regards,
Akshay
This was selected as the best answer
Max GMax G
Thanks Akshay! This is the solution.