> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-6/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-6/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://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/y8ecgXfRPFqB0H5FCpk6/image.png" 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://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/mA1cGeQQZps4zt9wN4Cc/image.png" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/C3S60sn3J3HGE2njfkxy/image.png" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/SFz3n5arSrEXg5UKiSHI/image.png" 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://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/R4ehDbhdIbTe7yIBNoYx/image.png" 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 %}