# Creating Custom Column and Custom Expressions

### You have the ability to create a custom column in your data sets to create a custom column, and you can define custom expressions. Let's explore how to do that.

Lets look at the following example. Where you want to create a custom column called "Amount in Canadian Dollars"&#x20;

1. First you have to select the data set "Borrows"&#x20;

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FWcswt5glPmkc4Aa9FlNN%2FScreenshot%202023-06-24%20193452.png?alt=media&#x26;token=4db9dd93-5bcd-4bcf-9fa2-7541044cc086" alt=""><figcaption></figcaption></figure>

2. Locate the "Show Editor" button and click on it. This will open the editor interface.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FfDBHYOONoY1Rizu4Slj3%2FScreenshot%202023-06-24%20193904.jpg?alt=media&#x26;token=d4c1fc1c-77df-4b66-b670-2cc1d9bd9c8f" alt=""><figcaption></figcaption></figure>

3. Look for an option or tab to add a custom column. Click on it to proceed.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2F281kS4n59FP50um1kcKD%2FScreenshot%202023-06-24%20194045.png?alt=media&#x26;token=88b7cba5-bc51-410b-9a50-96beb2ccfdec" alt=""><figcaption></figcaption></figure>

4. You'll find a text field where you can enter your formula. To convert an existing amount into Canadian dollars, the formula is given below in a screenshot Then provide a suitable name for your custom column, such as "Amount in CAD"

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2FwWbjwMzc2vVd2Yrbj72c%2FScreenshot%202023-06-24%20195141.jpg?alt=media&#x26;token=d4fddb3e-8cc0-44b5-a72d-c6348881b5b2" alt=""><figcaption></figcaption></figure>

5. Once you have entered the formula and named the custom column, click the "Done" or "Apply" button to save the changes.

<figure><img src="https://411387007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmieVdsFLVYWfiCpr2WSr%2Fuploads%2F2wOAZCeo4zqIKLhxsN9d%2FScreenshot%202023-06-24%20213658.png?alt=media&#x26;token=3df2ad6e-f7ec-4d64-a7c6-df85a9f6d24a" alt=""><figcaption></figcaption></figure>

By following these steps, you can create a custom column and utilize custom expressions to manipulate and visualize your data more customized and meaningfully.
