# Calculation functions

## 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

• ### Compound Functions

Find out about common compound functions, along with tips on implementation

• ### 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, MAILTO, MAKELINK, 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

• ### Time and Date Functions

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