Salesforce Docs Portal

Create a Calculated Field

Calculated fields are fields that don't exist in the underlying data and are defined with a formula. Calculated dimensions are qualitative, categorical fields used to group, classify, and segment data. Calculated measures are quantitative, numerical fields that are aggregated.

Required Editions

Available in: All editions supported by Data 360. See Data 360 edition availability.
User Permissions Needed
To create a calculated field:

Permission set:

  • Data Cloud Architect

AND

Semantic Models object
  1. In Data Cloud, on the Semantic Layer tab, select a data model.
  2. From the New dropdown, select Calculated Field.

    The New Calculated Field window opens.

    Selecting Calculated Field under New

  3. Configure the calculated field settings (field type, data type, name, and so on). See Configure Calculated Field Settings.
  4. To add filters, click Filters. See Add Filters to a Calculated Field.
  5. Write the formula. This formula is the substance of the calculated field. See Write a Formula in a Calculated Field.
  6. Click Validate to test the formula. Resolve any errors as needed.
  7. When the calculated field is properly defined, click Save.

    Selecting the type of calculated field under Field Type and adding filters

Note
Note If the formula refers to multiple data objects, the calculated field appears under Calculated Fields in the left pane. If the formula refers to a single data object, the calculated field appears as in that data object—expand the data object to view it.