Cell functions

Use the cell formula functions to add filters to queries and query-based views, and to set thresholds for situations and query-based views. The functions that are available depend on the type of attribute (numeric, text, or time) and in which editor you are working: Query, Situation, or Properties (Filters and Thresholds tabs).

Numeric attributes	Text attributes	Time attributes
Value of expression	Value of expression	Return a subset of the string
See if value is within a range	Return a subset of the string	Scan for string within a string
Change in value	Scan for string within a string	Compare date/time
Percent change in value	Check for Missing Items	Compare to time +/- delta
See if Null (no value) has been detected	See if Null (no value) has been detected	See if a time is within a range
	Scan for a string based on Regular Expression pattern	Scan for a string based on Regular Expression pattern