English
logo

  1. Calculation functions

Calculation functions

Featured resources

All functions

All functions

Use functions to perform calculations with your data, change the format of your data, and more.

LOOKUP

LOOKUP

Use the LOOKUP function to look up values in a source module or list and display the values in a target module. 

FINDITEM

FINDITEM

FINDITEM searches for a text value within the names and codes of the items or time periods in a given list or Time.

Calculation resources

  • Functions
  • Formulas
  • Common formula errors
  • Convert between data types
  • Excel comparison
  • Excel equivalent formulas

Additional resources

  • Formula usage tips
  • Precision differences and large number calculations
  • Optimize time calculation performance
  • Reverse lookup
  • Time aggregation
  • Operators and constants
backToTop

title

caseportalLink.text

registrationLink.text

emailLink.text

callLink.text

Disclaimer

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

© 2025 Anaplan, Inc. All rights reserved.
  • Privacy policy
  • Terms of use