> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-5/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/self-service-visualization-5/design-canvas/create-calculated-field/creating-a-formula/summary-level-formula.md).

# Summary Level Formula

This section describes Summary Level Formula field.

{% hint style="success" %}
*Check out the illustration on creating a Formula Field at the Summary level.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FqpK5tIRvTE33cx6crVFf%2FSummary%20Level%20Calculated%20Field.mp4?alt=media&token=616adf95-cd6f-4b9b-b3e8-d3bb1f05ed3a>" %}
***Summary Level Calculated Field***
{% endembed %}

The user can also create a formula field choosing the ***Summary Level*** as a level option from the Formula field editor window.

* Navigate to the ***Design*** page of the report.
* Click the ***Create Calculated Field*** icon.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FQjJAEmX4GbeR7ndw5zDE%2Fimage.png?alt=media&amp;token=aa5fb40f-c5eb-40c2-8cce-35817b1d8689" alt=""><figcaption><p><em><strong>Accessing Calculated Field icon</strong></em></p></figcaption></figure>

* The ***Create*** ***Calculated Field*** window appears.
* Navigate to the ***Formula*** tab (It is the default tab).
* Give a name to the new field.
* Choose ***Summary Level*** from the Level drop-down menu.
* Select a ***Save as*** option (It allows only ***Measure*** as the ***Save As*** option).
* Select fields using the Fields tab.
* Select an Operator from the Operators column.
* Enter a Formula Expression using the ***Fields*** and ***Operators***.
* Click the ***Save*** option.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FhW93sixcUzhxqT9MSEwj%2Fimage.png?alt=media&amp;token=e381e7c8-6978-43c9-b8a6-310101621051" alt=""><figcaption></figcaption></figure>

* A notification message ensures that the Formula field is created.&#x20;

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2F0wWTt0TBPzP1NMC1lGzs%2Fimage.png?alt=media&amp;token=21385e84-6dbf-41c5-858d-fc4ca8e9e233" alt=""><figcaption></figcaption></figure>

* A new ***Formula Field*** gets created and added to the list of dimensions and measures.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FbUrUD1NGfGTXPwnS2xkO%2Fimage.png?alt=media&amp;token=5737e7d9-e1d2-4866-b80b-9d175fc801f9" alt=""><figcaption></figcaption></figure>

* Add the newly created ***Formula Field*** to the top bar together with the earlier existing columns taken to create the new column.
* Click the ***GO*** option.
* The ***Formula Field*** data gets displayed in the current View for the users to validate the Formula.

<figure><img src="https://3555642236-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FeoiF50QZ72fn76mlMbmP%2Fimage.png?alt=media&amp;token=44445200-ca97-4745-8090-4771981b89d8" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>*

* *The **Summary level** Formula Field only gets saved as a **Measure**. It can't be saved as a Dimension to the Data Store.*
* Summary Level will not be listed for the space where the ***MongoDB*** server is configured in the ***Admin Settings***.
  {% endhint %}