Formula functions

Use the functions provided in these editors to write formulas: Situation, Query, Properties Filters tab, and Properties Thresholds tab.

Formula function types
With over a dozen cell and group functions available, you can build sophisticated filters for reporting only what matters to you, thus saving time and network resources. Likewise, you can build thresholds in table views and conditions in situations that trigger alerts to keep you informed of important changes in your managed network.
Attribute and attribute group characteristics
Formula functions treat attributes as numeric, text or timestamp. Attributes also have other characteristics that further categorize them and inform your choice of formula function or query-based view..
Boolean AND and OR
The tabular editors work with Boolean AND and OR logic.
Formula editor menu
The formula editor menu has functions for editing the expressions, inserting rows, and deleting rows and columns.
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).
Group functions
Use the group functions in the Query editor or Situation editor for attribute groups that return multiple rows of data or a single-row attribute group that has been configured for historical data collection. With the exception of COUNT, which can be used by all attribute types, group functions are available only for numeric attributes.

Parent topic: Working with the Cloud Pak System Software Monitoring Portal