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

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 the ancestor of the second. An item is the ancestor of another if it is at a higher level of a list hierarchy.

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.

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.