---
schema_version: "1"
id: 42d9c669f340d7400fc16084f8ec7f7e85cc87ff1e1a79c117b486030e481976
title: Configure Calculated Field Settings
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/c360_a_sl_calc_fields_calc_field_settings.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_calc_fields_calc_field_settings.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 0cf6daf3b1a51538a19cd3d90f0f2aac4f942ee6dc0167b3598fb1a1e5e26931
description: Like all fields, calculated fields have a field type of dimension or measure. Depending on the field type, calculated fields have additional field settings or metadata to be configured, such as data role, aggregation type, or sentiment.
products:
  - Data 360
release: "264"
---
# Configure Calculated Field Settings

Like all fields, calculated fields have a field type of dimension or measure. Depending on the field type, calculated fields have additional field settings or metadata to be configured, such as data role, aggregation type, or sentiment.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: All editions supported by <span>Data 360</span>. See <a href="https://help.salesforce.com/s/articleView?id=data.c360_a_dc_editions.htm&amp;language=en_US" target="_blank"><span>Data 360</span> edition availability</a>.</td></tr></tbody></table>

<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:left;vertical-align:top;" id="d7245e63">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d7245e63 ">To configure a setting:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d7245e63 ">
              <p>Permission set: </p>
              <ul>
                <li>Data Cloud Architect</li>

              </ul>
              <p>AND</p>
              <p style="margin-bottom:0;">Semantic Models object</p>
            </td>

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

1. Open the New Calculated Field window or Edit Calculated Field window.
2. From the New dropdown, select **Calculated Field**. Or, click on a calculated field in the left pane.
3. For Field Type, select **Dimension** or **Measure**. Dimensions are qualitative. Measures are quantitative and have an aggregation.
4. From the **Data Type** dropdown menu, select the type of data the calculated field represents.
    1. Valid data types are Number, Text, Date, DateTime, Boolean, Percentage, URL, Email, Phone Number, and Currency.
    2. When you define the formula, the output must match the data type of the calculated field. For example, if the data type is Boolean, the formula can't have a numeric output.
5. Enter a unique name.
6. (Optional) To define advanced settings, expand **Advanced**. What options appear depend on the field type and data type. Not all options are always available and at times values are view-only.
    1. Description: A description to help users or agents understand the purpose of the calculated field.
    2. API Name: Enter a unique API name. You can’t edit the API name after the field is created.
    3. Aggregation: Specifies the aggregation for measures. If the formula contains aggregations, this should be UserAgg. Valid options include: UserAgg, Sum, Average, Min, Max, Median, Count, CountDistinct, StdDev, StdDevP, Var, and VarP.
    4. Decimal Place: For measures. The default is 2, use the - and + buttons to adjust between 0-9 decimal places.
    5. Data Role: Discrete or continuous. Dimensions are usually discrete and measures are usually continuous. For date and datetime fields in particular, whether they are discrete or continuous has a large impact on their behavior.
    6. Sentiment: Indicates the sentiment of an upward trend. Valid options are: Up is Good, Up is Bad, Up is Neutral.
    7. Treat Null as Zero (checkbox): Selecting this checkbox means nulls are treated as zeros for operations.
    8. Field Visibility (toggle): Whether or not the field is visible in the left pane.
7. (Optional) For filters, see [Add Filters to a Calculated Field](https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_calc_fields_add_filter.htm&release=264.0.0&type=5 "Filters let you choose which data can be in the formula expression. Filters help you increase the accuracy of your measures.").
8. For the formula section, see [Write a Formula in a Calculated Field](https://help.salesforce.com/s/articleView?id=analytics.c360_a_sl_calc_fields_formula_build.htm&release=264.0.0&type=5 "Formulas define how a calculated field is computed. How a formula is written is called its syntax. A formula may contain functions, fields, operators, literal expressions, parameters, or comments.").
9. Click **Validate** to check your calculated field.
    1. Verify that the field type, data type, and formula aren't in conflict. Not all combos make sense, such as a continuous Boolean.
10. Click **Save**.