---
schema_version: "1"
id: 854e270a21f5e527414996bb84629bc018ca10f166583d03c27e859cf183589d
title: Create a Calculated Measurement From The Calculated Measurement Tab
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_measure_create_from_tab.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_measure_create_from_tab.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 7dfe8ee6e881eeb6e5f04174e860340c4932b4f38f0b94b708c8820b9462babc
description: Create a calculated measurement on top of existing data that you can refer to across your workspace.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Calculated Measurement From The Calculated Measurement Tab

Create a calculated measurement on top of existing data that you can refer to across your workspace.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d40608e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d40608e38 ">To create and manage calculated measurements:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d40608e38 ">Power User or Admin</td>

          </tr>
        </tbody>
      </table>

1. On the **Connect & Mix** tab, expand **Measurements**, and then expand **Calculated Measurements**.
2. Click **Add New**.
3. In the **General** section, define the calculated measurement.
    
    When setting the decimal places, the more places you specify, the more exact the calculation.
4. In the **Advanced** section define advanced settings.
    1. For **Total Aggregation Function**, select the function to calculate the total value of a query. For example, SUM, AVG, MIN, or MAX. Values that appear in separate rows of a display are all aggregated in the Total row. The Total Aggregation Function and the Aggregation Function—set in the expression section— should be the same.
    2. Set the granularity—Determine the level the calculations for the measurement takes place.
    3. To let null values be used in the formulas,, select **Treat Nulls as Zeros**
    4. To include the date in the granularity of the calculation, select **Include Date in Granularity**
5. In the **Expression** section, define the expression:
    1. Set the aggregation function to determine the calculation result for all the produced rows. When a granularity is set, the underlying calculation produces multiple calculation results for multiple rows. These rows must be aggregated into a single row of the displayed dimension.
    2. Create the expression that you want to base the calculated measurement on using the list of available measurements and functions. For example, if you want to calculate email open rate that uses email sends as the denominator instead of email deliveries, use this expression: `IFERROR([Email_Unique_Opens]/[Email_Sends], null)` The `IFERROR` function results in the calculated measurement returning null values when the email sends equal to 0.
    3. To add a function to your expression, click it, or start typing for auto-complete.
6. Click **Save**.