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 may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.