> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-visualization/self-service/design/formula-field-editor/creating-a-formula/record-level-option.md).

# Record Level Option

{% hint style="success" %}
*Check-out the walk-through on how to create a formula field at the record level.* 
{% endhint %}

<figure><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FeWAE4FgVMuZyWVJc0TLK%2FRecordLevel.gif?alt=media&amp;token=ae0537f6-2c15-4ff3-b02b-a65edaef11de" alt=""><figcaption><p>The Record Level Formula Field created with the Elastic Search Data Store configuration</p></figcaption></figure>

<figure><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F9eT4cPg6UPCqYVjRXKzM%2FFormula_mongodbconfigurespace.gif?alt=media&amp;token=58db9798-2a2c-4ad7-b20c-3c695a9a0c2c" alt=""><figcaption><p>The Record Level Formula Field created with the MongoDB Data Store configuration</p></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note</mark>: You can read the* [*<mark style="color:blue;">**Data Store Settings**</mark>*](/bdb-documentation/core-platform/platform-administration/admin-panel-options/configurations/data-store-settings.md) *configuration option provided under the* [*<mark style="color:blue;">**Admin Panel Options**</mark>*](/bdb-documentation/core-platform/platform-administration/admin-panel-options.md)*.*
{% endhint %}

* Navigate to the ***Design*** tab after selecting a Data Store to design a new view.
* Click the ***Formula Field Editor*** icon.

![Accessing the Formula Field Editor icon on the Design page](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FGiP4OV6mml3t6Vusu4ZK%2Fimage.png?alt=media\&token=a34523b9-05fa-4606-8a9c-b8ca39d029df)

* The user gets redirected to the ***Create*** ***Formula*** window.&#x20;
* Navigate to the ***FORMULA*** tab (opens by default)<mark style="color:purple;">.</mark>
* **Formula Name**: Give a title to the formula field<mark style="color:purple;">.</mark>
* **Save as**: Select an option from the drop-down menu to decide the type of the Formula Field.
  * Dimension
  * Measure
* **Fields**: All fields from the selected Data Store list in this window. The users can select the required fields by tapping on them.
* **Operators**: All the available operations list in this window. The users can select the required operations to add and complete the formula.
* **Functions**: All the available functions list in this window. The users can select the required functions to apply them to the chosen field.
* Click the ***SAVE*** option to save the formula.     &#x20;

![The Create Formula window](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FHWFY8sBb15PeSikdHuw8%2Fimage.png?alt=media\&token=40ef3bcf-d159-466c-be27-464f033d475f)

* The newly created formula field gets added to the selected Data Store.

&#x20;   ![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2F5xVQ8ZiYmFe5EjD5NMTQ%2Fimage.png?alt=media\&token=4e699091-bc17-405c-bf23-4c2f68fb377f)

{% hint style="info" %} <mark style="color:green;">Please Note:</mark> *The Formula Fields that are created with the **Record Level** option can be saved as either Dimension or Measure. Based on the selected option for the **Save as**, the displayed **Fields** may vary in the right-side panel.*
{% endhint %}

The following image displays how the fields get changed when a new Formula Field is created at the Record Level:

<figure><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FAGk4MqCo5G4cZpEn44Jx%2Fimage.png?alt=media&amp;token=3ba39aba-8f00-4aa1-817f-ae168ae129b0" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> Double click on the **Functions** or **Operators** from the Formula Field Editor where the MongoDB server is configured in the Admin Settings as it generates one expression. The **tan** function does not support the MongoDB server.*
{% endhint %}