# Custom Values

To convert a dataset value to USD use the steps below:

## Show custom values in data tables

1. After selecting the dataset from Indexed data, locate the Settings button at the bottom left corner of the page.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FvhXkDMcrsyLOrUeeXtnU%2FScreenshot%202023-07-12%20151206.jpg?alt=media&#x26;token=005f39d0-b49e-4a2b-b97e-141b34f6260f" alt=""><figcaption></figcaption></figure>

2. Click on the Column name and then click on the Settings button to access additional options.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FekkSgWhgBapbgjW6UqK0%2FScreenshot%202023-07-12%20151239.png?alt=media&#x26;token=7dc0afbb-4228-45d8-b943-ac888c873ae7" alt=""><figcaption></figcaption></figure>

3. Within the Column formatting options choose the "Style" to "Currency".

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FKelOeOZ2LT6aGJnbFh6B%2FScreenshot%202023-07-12%20161306.jpg?alt=media&#x26;token=82e9be59-6074-4082-84af-4fb820860d5b" alt=""><figcaption></figcaption></figure>

4. Scroll down until you find the "Multiply by Number" section, Note somewhere the value "1e-18" and then Copy-paste here to convert the value to USD.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2Fz1HwzmY82mThktWqH9PD%2FScreenshot%202023-07-12%20154745.png?alt=media&#x26;token=584ed18f-b1c3-457e-96d3-fa98187c22ba" alt=""><figcaption></figcaption></figure>

5. Once you've entered the value, click on the "Done" button to save the changes. Now, you should be able to see the converted value in USD format.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FDJspNDUc45dt44G3BfsA%2FScreenshot%202023-07-12%20170746.png?alt=media&#x26;token=27b4f683-7f8a-495a-982c-3dadd07a7825" alt=""><figcaption></figcaption></figure>

## Show Custom values on charts

1. Click on the settings button which is located in the bottom left corner of the chart.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FJWRCkcFhXZCXICysEDBN%2FScreenshot%202023-07-13%20002742.png?alt=media&#x26;token=458ea85d-ba5b-4601-b41f-abbe0e15eece" alt=""><figcaption></figcaption></figure>

2. Then Click on The Three dots " ... " next to the Sum of amount.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FHOdDDh8pLBcLoAblfkHd%2FScreenshot%202023-07-13%20002852.png?alt=media&#x26;token=9bf44895-3bef-4ab3-ac9d-13d8b86b8d1b" alt=""><figcaption></figcaption></figure>

3. Within the formatting options choose the "Style" to "Currency" & in "Multiply by Number" section, Note somewhere the value "1e-18" and then Copy-paste here to convert the value to USD.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FKBWbSy76WELf3XacZRq6%2FScreenshot%202023-07-13%20003028.png?alt=media&#x26;token=2e5bced4-f823-49f8-8f52-c293dae85f56" alt=""><figcaption></figcaption></figure>

4. After the changes are done in formatting, Now you can see the amount is showing in USD

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2F7WuFM7UT0lsIGFUIjBKF%2FScreenshot%202023-07-13%20003934.jpg?alt=media&#x26;token=3ac74a26-3ca0-4b49-abc5-f2e372964443" alt=""><figcaption></figcaption></figure>

These steps will help you format and convert the dataset value to USD using the specified settings.