Miscellaneous functions

These functions can be used in a formula, but they do not fit into a standard category for function families.

Table 1: Miscellaneous functions

Function

Syntax

Description

GroupValues(column, ListOfValues, newValue)

  • column: User object to apply the grouping to
  • ListOfValues: List of values to be grouped
  • newValue: Value that will replace the grouped values

Groups a list of values.

For example:
GroupValues(CountryColumn, ["USA", "India", "France"], "My Countries")
returns "My Countries" when the CountryColumn column contains "USA", "India", or "France"

ToNumber(param)

param: Parameter to convert

Converts any type of parameter to a numeric value. Numbers are truncated to zero decimal places.