Logical functions - Anaplan Technical Documentation

Use logical functions to create conditional formulas, retrieve data, return Boolean values based upon the properties of data, and more.

Title	Description
COMPARE	The COMPARE function compares text values. If they're the same, it returns 0. If the first text value is greater, it returns 1, and if the first text value is less, it returns -1.
IF THEN ELSE	Tests a Boolean argument and returns one of two results based on whether it is true or false.
ISACTUALVERSION	The ISACTUALVERSION function returns a TRUE result for the version that is set as Actual in a model. It returns FALSE for all other versions.
ISANCESTOR	The ISANCESTOR function takes two list or time period values. It returns a Boolean value of TRUE if the first is an ancestor of the second. Ancestors of an item are its parent, its parent's parent, and so on.
ISBLANK	The ISBLANK function returns true for values that are blank.
ISCURRENTVERSION	The ISCURRENTVERSION function returns a TRUE result for the version that is set as Current in a model. It returns FALSE for all other versions.
ISFIRSTOCCURRENCE	The ISFIRSTOCCURRENCE function returns a Boolean value of TRUE for the first occurrence of a value in a list dimension.
ISNOTBLANK	The ISNOTBLANK function returns a Boolean result for values that are not blank.
LOOKUP	Use the LOOKUP function to look up values in a source module or list and display the values in a target module.
SELECT	Use the SELECT function to return values from a given list item or time period.