> 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="/files/8PTippqmlXGKT4NZMSRJ" alt=""><figcaption><p>The Record Level Formula Field created with the Elastic Search Data Store configuration</p></figcaption></figure>

<figure><img src="/files/lQGhd52P0QdiYsBiRPXs" 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](/files/wPCZQSeBZYrXaRNC1V8P)

* 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](/files/RIeoEDk5WjUKXtiui6bT)

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

&#x20;   ![](/files/a8voZsVxKReY6rWUk0Ma)

{% 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="/files/LDkAyEd7fWoTGhQ4lPRH" 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 %}