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.

Disclaimer

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