---
schema_version: "1"
id: c5e2449bef50faec7e697f7714d5b4e9251fe0e8e953d647c05181540162f069
title: MDP Create a Calculated Measurement
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_measure_create_from_tab.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_measure_create_from_tab.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 3e3322e5e415cc6010a3b60a139f54164f405d6b9cb8510a239652b97b1bbef9
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"
---
# MDP Create a Calculated Measurement

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

1. On the **Harmonize** tab, expand **Calculated Fields**, 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**.