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. |