This article applies to:

CollectValues Function

Relevance:

Variable occurrences within this function do not contribute towards the overall relevance of those variables.

Consequently, such variables must occur in at least one other context for them to be considered relevant.

Description:

The list of known values for each of the collected expressions.

note

This function is always evaluable.

Returns:

Any*

Parameter:

Parameter	Data Type	Description
*	Any

Examples:

When using functions inside a field, remember the field brackets:

{CollectValues(VariableName)}

Expression	Result
CollectValues( VarA, VarB, VarC ) where VarA="a", VarB="b" and VarC is unknown	List( "a", "b" )
CollectValues( VarA, VarB, VarC ) where VarA="a", the repeated variable VarB has repetitious values "b1", "b2" and "b3", and the repeated variable VarC has no values	List( "a", "b1", "b2", "b3" )
CollectValues( VarA, VarB, VarC ) where no values are known	List( )