Define and Run a Calculation that Runs the Map and Executes the Currency Formula
  • 1 Minute to read
  • Dark
    Light
  • PDF

Define and Run a Calculation that Runs the Map and Executes the Currency Formula

  • Dark
    Light
  • PDF

Article summary

After you have created the data map and created a formula to use the exchange rate, create a calculation that runs the map and formula.

  1. Go to Model, Calculation.

  2. Select the model to receive the exchange rate.

  3. Give the calculation a name.

  4. Select Map under Type, and enter the name of the data map.

  5. Select Formula under Type, and enter the name of the formula.

  6. Select the Variables column and click Variables Manager to specify the Scenario and Time members to receive.

ModelingImages01to50image26ExchangeRatesCalc1.png

You can also add a row to download the exchange rates. This ensures that your model always has the latest exchange rate data from Planful applications.

Note:

The scope defined previously on HACPM_Financial would need to be redefined under the model that contains your data.

ModelingImages01to50image27ExchangeRatesCalc2.png

After running this calculation, data appears in the model as follows. The raw data was 100 euros. The Common Currency member is locked since it is a calculated member.

ModelingImages01to50image28ExchangeRatesView5.png


Was this article helpful?