1. Calculation functions
  2. All Functions
  3. Logical Functions
Name Description
AND Enter several conditions and the AND function tests to see if all conditions are met.
BLANK When the result is text, list, time period, or date-formatted the result can be set to be BLANK.
COMPARE Compares text values; result is 0 if they match, 1 or -1 if not matched.
FIRSTNONBLANK Shows the first non-blank text, list or date cell and uses the mapping to determine where to post the result.
IF THEN ELSE Conditional formula.
IF...ISNOTBLANK Test to see if a date, text, time period, or list-formatted cell is not blank.
IF…ISBLANK Tests whether a date, text, time period or list-formatted cell is blank.
IF...AND Tests whether 2 or more conditions are met.
IF...NOT Tests whether condition is not true.
IF...OR Tests if any of 2 or more conditions is met.
ISANCESTOR Tests whether a specified list item is an ancestor of the second specified list item or whether a specified time period is an ancestor of a second specified time period (result is Boolean-formatted).
ISBLANK Tests whether an item is blank (the item must be date, text, list, or time period-formatted and the result is Boolean-formatted).
ISFIRSTOCCURRENCE Tests if a value in the source (first parameter) is the first occurrence of that value within the source (result is Boolean-formatted).
ISNOTBLANK Tests whether an item is not blank (the item must be date, text, list, or time period-formatted and the result is Boolean-formatted)
LASTNONBLANK Shows the last non-blank text, list or date cell and uses the mapping to determine where to post the 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.
NOT Tests to see if a condition is not met (result is Boolean-formatted).
OR Tests to see if any of two or more conditions is met.
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 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.
TEXT Converts a numeric value to text.