To create a new formula:

1.In Formula Name, enter a name for the formula. This name will appear in the grid as the new member’s name.

2.In Formula Format, choose a display format for the calculated values, if different from the default.

3.Change the precedence in the Precedence field, if required, by selecting a number between –5 and 200. When there are multiple formulas affecting the same cell, the precedence determines the order in which the formulas are applied, starting from the calculation with the lowest precedence.

4.In Formula Type, choose the function to apply. Functions are organized in groups. For example, to calculate the average number of orders for selected products, choose the Average function in the Math group. Tooltips provide descriptions for the available functions. For details, see Math Functions, Customized Functions, and Time Functions.

Click OK.

Notice that the formula syntax displays below the Items panel.

For example, to calculate the difference between the sales of alcoholic beverages and dairy drinks, you choose the Difference function. This function calculates the difference between two parameters (members).

5.In the grid, click the member that will participate in the formula. To add more than one member, use Ctrl-click or Shift-click.

6.Drag and drop the member(s) to the Items box in the Formula Pane.

You can also use the Member Selection button to select dimension members.

Make sure the items are in the correct order in the formula. You can use the buttons on the right to move and remove items.

The formula syntax now shows the parameters replaced with the selected members.

7.Click Apply.

The calculated formula appears as a new member in the grid. The formula icon appears next to the member’s name. In the example below, Alcohol-Dairy Difference is such a member.