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