1. Calculation functions
  2. All Functions
  3. Miscellaneous Functions
Name Description
CODE Returns the code of a list item.
COLLECT Collects the data from the original line items from one or more modules (module must have a line item subset as a dimension).
CURRENTVERSION Returns the value of the current version as defined under Settings, Versions.
FIND Look for a text string within a text-formatted item, starting at a specified character number (result is a number that denotes the character position).
FINDITEM Matches text to an item of a list or matches text to a list item of a time period list (can match on item name or code).
ITEM Returns the formatted list item or time period-formatted line item.
LEFT Extracts a substring from a string starting at the leftmost character.
LEN Variant of LENGTH. Returns the number of characters in a text string.
LENGTH Returns the number of characters in a text string.
LOWER Converts text to lowercase.
MAILTO Composes the To, cc, Bcc, subject and body of an email.
MAKELINK Composes a clickable URL.
NAME Converts a list item or time period to text.
NEXTVERSION Returns a value from the next version.
PARENT Can be used against list-formatted items to return the parent of a list item or against time period-formatted items to return the parent time period.
PREVIOUSVERSION Returns a value from the previous version.
RANK Orders a set of values and assigns rankings from 1 to a specified ending rank.
RANKCUMULATE Allows you to cumulate line item values based on ranking criteria, which might contain groupings. Can be used against lists but not time.
RIGHT Extracts a substring from a string starting at the rightmost character.
TEXT Converts a numeric value to text.
TRIM Replaces multiple text spaces between words in text, and at the beginning or end of the text, with a single space.
TEXTLIST Lists a series of text items in a single result cell.
UPPER Converts text to uppercase.
VALUE Converts a numeric value in a text field to a number format.