Creating a Custom Formula

The Create Calculated Measure feature is available in the menu of the metric field name. The Create Calculated Measure is also available under User Defined Measure when the data field is under the Layout Configuration and table report.

Refer to Use Case Scenarios for examples of custom formulas.

To create a Calculated Measure Procedure:

  1. Go to Main Menu [] > Insights.

  2. Select the measure field name in the Layout Configuration.

  3. Select User Defined Measure > Create Calculated Measure.

    Measure options with User Defined Measure selected

  4. Enter the Display Name of the formula.

  5. Select a Format.

    Calculated Measure Properties showing the Format menu with General Number highlighted

  6. Select the number of Decimal Places.

  7. Select the measure field in the column to the left of the Layout Configuration.

  8. Drag the metric name to the Layout Configuration. The MDX formula appears.

  9. Enable or disable the subtotal calculations options. The subtotal appears on the resulting report.

  10. Click OK. The custom formula appears on the report.