Skip to main content

Create a calculated member

A Calculated Member is a reusable formula whose value is calculated using other member values, mathematical calculations, and logical operations. The member is dynamically calculated at the time of use.

  1. Click New resource > Calculated Member.

  2. Drag a measure from the Dimension Tree to the Formula placeholder.

  3. Right click on the Formula placeholder, or type into the placeholder, to find an operation. Select the operation you wish to perform (e.g., +, =, >, If , etc.).

    Calculated member formula field context menu

    Searching inside the calculated member formula field

  4. Drag another measure from the Dimension Tree to the Formula placeholder.

  5. Repeat steps 2-4 until your formula is complete.

  6. Click Save. Specify a name and location and click OK.

Optional steps​

Number formatting​

Use the Number format controls in the Home design panel to specify a format for the calculated member's numeric value to be returned.

Calculation order​

Calculation order can be specified, but the default Post Aggregation option will be used if left blank.

Show the calculated member in the Dimension Tree​

  • Directly under a specific hierarchy or member - Drag a hierarchy or member from the Dimension Tree into the Parent hierarchy or member placeholder. The calculated member will appear under this parent in the Dimension Tree.

  • Within a specific measure group - Drag a measure group into the parent measure group placeholder to have the calculated member appear under that measure group in the Dimension Tree.

  • Within a subfolder - Specify the desired folder name in the Display folder text box in the Home design panel. The folder is displayed under the specified parent hierarchy and/or measure group.
example

To put the calculated member in a folder inside the "Sales invoice line" measure group, drag "Sales invoice line" into the Parent measure group placeholder:

Parent measure group

Then specify a folder name in the Display folder text box:

Display folder

Once the calculated member is saved, and the Dimension Tree is refreshed, it will appear as follows:

Calculated member in a folder in a measure group in the dimension tree

Make the calculated member's caption dynamic​

You can make the calculated member's caption dynamic by using the Caption placeholder.

  1. Specify the member you want to use in the caption field, e.g. Current Date.

  2. When saving the calculated member, use "@@" as the caption placeholder.

Calculated member with dynamic caption configured

  1. Use the calculated member in an analytic to see how the variable in the calculated member name is replaced with the value of the member you specified in the caption.

Calculated member with dynamic caption in an analysis

Calculated Members reference