Anaplan provides a range of functions and operators to define formulas with. Apply these formulas to the data in your models.

Formulas can be as simple or as complex as necessary to achieve the business objective. The formula editor is always visible when you’re working in a module, and you can jump in and out of it whenever you like.

Formulas can contain functions, expressions, references, operators, and constants.

Element | Description |

Function | This takes one or more values and performs a defined operation to return a result. |

Expression | This takes one or more values and performs a calculation or comparison to return a result. Expressions normally include operators and constants, mathematical symbols that specify the calculation to be performed. |

Reference | This takes one or more values from modules, line items, and list properties in Anaplan. |

Constant | This is a value that doesn't change. For example, a date, text, or a number. |

Always consider performance when building formulas. Anaplan locks the model while formulas are verified, and batches incoming data changes together with some model changes (like list edits) and views. This means it can push them all through to the model in one batch when the lock is released.

The arguments used in functions must be in the correct data format for the function to work correctly. Some functions are designed exclusively to change the format of data and are useful when building formulas.

In Anapedia, optional arguments in calculation functions are enclosed in [square brackets]. You can choose whether to include optional arguments when you build formulas. When there's no optional argument, a function performs according to its default setting.

You can view all functions in alphabetical order. You can also filter by title, or view by category or calculation engine type.

To see all functions in action, go to the Modeling showcase and download the Formulas & Functions app.

For help with errors when entering formulas, see Common formula errors.