Use the CHANGE formula function in a situation to compare the change between the value of the current data sample and the previous sample.
Change
in value- The CHANGE function takes the amount of change between the sampled value of the attribute and the previous value, then compares it with the value you enter here. If the result meets the comparison, the situation is true. Valid values are numeric integers.
- Example
- In the following example, the situation becomes true if the Virtual
Bytes have increased by at least 100 bytes since the last data sampling.
During the first monitor iteration the value of Virtual Bytes is 200
and during the second iteration the value is 500, which is an increase
of 300 between samples, thus the situation is true.
CHANGE (Virtual Bytes) >= 100 - Restrictions
- You can have only one CHANGE function in a situation.
- The CHANGE function must be written on row 1 of the formula editor; all subsequent rows are disabled.
- You cannot combine the CHANGE function with a PCTCHANGE, MISSING or group function in a situation.
- A formula with the CHANGE function can use values from one attribute group only.
- The function list shows CHANGE for monitoring agents that are of the correct version; older versions will not display CHANGE in the list.
- If the expression that is responsible for a situation event uses this function, the event results workspace will show neither the attribute value nor the expression that should display when you hover over an initial situation value.
- Hexadecimal numbers
- When entering a hexadecimal value in a cell, prefix the number with zero and the letter “x”, as in 0x123ab for hex value 123ab.