LABELS function will return an array of labels for a specified attribute or calculated value.

Syntax

LABELS(x)

Parameters

x = Attribute/Calculated Value which the labels wish to be returned.

Data Type Returned

Will return an array of text values that represent the labels.

Examples

Using a list attribute that has been assigned a code of “Prob”, which has 3 labels of “Low”, “Med” and “High”. The item in question has a “Prob” value of “Med” but all possible values will be returned.

LABELS(“Prob”) will return “Low,Med,High”