Logical Functions - Anaplan Technical Documentation

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

Name	Description
IF THEN ELSE	Tests a Boolean argument and returns one of two results based on whether it is true or false.
ISANCESTOR	Tests whether a specified list item or time period is an ancestor of a second specified list item or time period. Returns a Boolean result.
ISBLANK	Tests whether a date, text, list, or time period type item is blank. Returns a Boolean result.
ISFIRSTOCCURRENCE	Tests if a value in the source (the first argument) is the first occurrence of that value within the source. Returns a Boolean result.
ISNOTBLANK	Tests whether an date, text, list, or time period type item is not blank. Returns a Boolean result.
LOOKUP	Looks 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.
SELECT	Selects a specific item from one or more of the hierarchy lists.
SELECT & LOOKUP	Selects a specific item from one or more of the hierarchy lists, then looks up a value based on matching that selection.
SUM	Sums 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 & LOOKUP	A 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 & SELECT	First 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.