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”