Developer Documentation Library > Scripting > UNICOM Intelligence Function Library > Miscellaneous functions > DefinedValues
 
DefinedValues
Returns a value from a list of values based on the current rotation state.
Syntax
DefinedValues([Vals, ...])
Parameters
Vals
Type: None
A comma-delimited list of values.
(return)
Type: None
A single value from the values specified in Vals.
Remarks
This function takes a variable length argument list where the argument values can be of data type. On each call to the function, the next value in the list is returned based on the rotation state. If no arguments are specified, a NULL value is returned.
If DefinedValues continues to be called after all the values have been returned, the function loops back to the first item in the list.
Example
This function is most often used in Reporter to insert user-defined values as a table row or column by using a Derived element. For example, in the following axis expression, the Derived element adds a row or column of user-defined values when applied to a table.
{.., P 'Population' Derived('DefinedValues(108.8, 88.3, 76.2, 39.7)')}
See also
Encrypt
Miscellaneous functions