Skip to main content

Working with Calculated Fields

Use this page to create calculated fields so you can add reusable business logic directly inside a model.

Calculated fields let you generate custom columns with expressions similar to formulas in spreadsheet tools.

List of expressions​

See a full list of expressions supported in calculated field.

Create a calculated field​

  1. Go to the diagram of the model you want to create a calculated field.

  2. Click the "+" icon next to the "Calculated Fields" section.

    cf_2

  3. Name this calculated field.

  4. Select a function you want to use in this calculated field.

    cf_4

  5. Select the column which you want to apply this function.

    cf_5_1

    You can apply a column from another model through the relationships already defined in this model.

    cf_5_2

  6. Click "Save" to create.

Update a calculated field​

To update calculated field settings in a model:

  1. Click the "..." icon next to the calculated field on the model diagram.
  2. Choose "Edit".
  3. You can edit the Name or expression of this calculated field

Delete a calculated field​

To delete a calculated field:

  1. Click the "..." icon next to the calculated field on the model diagram.
  2. Choose "Delete".
Remember to deploy your changes

Deploy​

Please press the "Deploy" button on the navigation bar to synchronize any modifications in the Modeling page.

The navigation bar will show an Undeployed changes message if there are any new changes. undeployed

The navigation bar will show a synced message if all changes have been deployed. deployed