All functions
Review the full list of Anaplan calculation functions, in alphabetical order
Calculation functions
Features function reference topics
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.
Function reference topics
Aggregation Functions
Discover how to get values from a source line item using one or more mappings using ANY, ALL, AVERAGE, MIN, MAX, SUM and more
All functions
Review the full list of Anaplan calculation functions, in alphabetical order
Call Center Planning Functions
Perform accurate modeling of common operational scenarios, involving queuing to wait to be served by a person or a machine
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
Excel Comparison
See which Anaplan functions have an Excel equivalent to improve your model building skills
Financial Functions
Get up to speed with FV, IRR, NPER, NPV, PMT, PV and RATE functions for improved financial modeling
Formula Usage Tips
Read our handy guide to help you determine the best function to use for a given scenario.
Logical Functions
Perform complex calculations using popular logical functions such as AND, IF, LOOKUP, SELECT, SUM and more
Miscellaneous Functions
Work with Anaplan functions such as COLLECT, ITEM, RANK and more
Numeric Functions
Refer to this list of useful number functions like ABD, MIN, MAX, ROUND and others
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.
Time and Date Functions
Learn how to use popular date functions such as DATE, DECUMULATE, END, LAG and more