1. Calculation functions
  2. All Functions
  3. Logical Functions

Use logical functions such as IF THEN ELSE, LOOKUP, and SELECT as the basis of complex calculations in Anaplan.

NameDescription
IF THEN ELSETests a Boolean argument and returns one of two results based on whether it is true or false.
ISANCESTORTests whether a specified list item or time period is an ancestor of a second specified list item or time period. Returns a Boolean result.
ISBLANKTests whether a date, text, list, or time period type item is blank. Returns a Boolean result.
ISFIRSTOCCURRENCETests if a value in the source (the first argument) is the first occurrence of that value within the source. Returns a Boolean result.
ISNOTBLANKTests whether an date, text, list, or time period type item is not blank. Returns a Boolean result.
LOOKUPLooks up an amount from a source module using one or more mappings. Each mapping matches a list-formatted line item, a time period-formatted item, or property from the source with a dimension of the target line item.
SELECTSelects a specific item from one or more of the hierarchy lists.
SELECT & LOOKUPSelects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.
SUMSums values based on a list-formatted or time period-formatted line item or property in the source that matches a dimension in the target.
SUM & LOOKUPA formula that uses the SUM and LOOKUP functions. First it sums based on a list-formatted line item or property in the source, then looks up a value from a source module using one or more mappings.
SUM & SELECTFirst it selects a specific item from one or more of the hierarchy lists, then it sums values based on a list-formatted line item or property in the source that matches a dimension in the target.