Edit a formula

In synchronous models, a dimension must be locked before a formula can be applied to the dimension.

Select a dimension to edit.
On the shortcut menu, click Edit Formula.
On the Edit Formula command bar, enter the formula you want, and then click the Accept (check mark) button.

Tip:

You also can display and edit the formula for a dimension using the variable table.
You can use the Show All Formulas command on the shortcut menu to display the dimension name and formula for all the dimensions.
You can add a dimension name to the formula box by clicking a dimension.
You can use the Copy Link command on the Apply Formula shortcut menu to copy the link for the dimension which you are editing.