Calculation functions

Features function reference topics

Function reference topics

  • All functions

    Review the full list of Anaplan calculation functions, in alphabetical order.

  • Excel Comparison

    See which Anaplan functions have an Excel equivalent to improve your model building skills

  • Formula Usage Tips

    Read our handy guide to help you determine the best function to use for a given scenario.

  • Time and date Functions

    Learn how to use popular date functions such as DATE, DECUMULATE, END, LAG and more

  • Financial Functions

    Get up to speed with FV, IRR, NPER, NPV, PMT, PV, RATE, and more functions for improved financial modeling

  • Numeric Functions

    Refer to this list of useful number functions like ABS, MIN, MAX, ROUND and others

  • Logical Functions

    Perform complex calculations using popular logical functions such as AND, IF, LOOKUP, SELECT, SUM and more

  • Call Center Planning Functions

    Perform accurate modeling of common operational scenarios, involving queuing to wait to be served by a person or a machine

  • Aggregation Functions

    Use aggregation functions such as ANY, ALL, AVERAGE, MIN, MAX, SUM, and more to retrieve values based on mappings from source line items.

  • Miscellaneous Functions

    Work with Anaplan functions such as COLLECT, ITEM, RANK and more

  • Convert between Data Types

    Find out which functions can be used to converting the type of data to allow it to be used in a different context

  • Operators and Constants

    Improve your formula editing skills by using a range of operators and constants

  • Text Functions

    Anaplan provides a range of functions that enable you to work with text.


We update Anapedia regularly to provide the most up-to-date instructions.