Define a Formula that Calculates the Common Currency

Once you have the exchange rate(s) in your model, you can multiply all foreign values by the exchange rate to arrive at the equivalent in your local or common currency.

1. Go to Model, Formula.

2. Select the model and dimension that contains the values in foreign currency, local currency, and the exchange rate.

3. Give the formula a name.

4. Specify member selections or variables for all the other dimensions in the model under the Dimension column.

5. Specify the members that are to be included in the formula, then enter the formula in column B.

CC (common currency) = LC (local currency) * Exg Rates