Conversion formulas are used in the Conversion Rules form in Anaplan Financial Consolidation application. 

To access the form:

  1. Select the Maintain module.
  2. Select Conversion Formulas from the Conversion card. 

The pre-configured conversion formulas included in your Anaplan Financial Consolidation application are:

ALL_

[Average]

[EndRate]

[EndRate]-[HISTORICAL]

[EndRate]-[Average]

[EndRate]-[OpeningEndRate]

[EndRate]-[OpeningAverage]

[HISTORICAL]

-[HISTORICAL]

[OpeningEndRate]

[OpeningEndRate]-[OpeningAverage]

[OpeningAverage]

[Average]*[EndRate]

[Average]*-1
[Compute]

-[Compute]

[EndRate]*-1

  1. Select the Create icon from the upper right toolbar. 
  2. Enter the formula with square brackets [] surrounding it.
  3. Select Save from the toolbar.

You can create, delete, import, export, refresh, and save conversion formulas.

Select the ellipses on a row to create, duplicate, and delete the formula.