AX1633

GetFileGroupVariableEnablement function

Returns whether a picklist variable is enabled for a specified value in the picklist enablement column (True/False).

Syntax

GetFileGroupVariableEnablement("VariableName", EnablementValue, FileGroupID)

(missing or bad snippet)

All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.

(missing or bad snippet)

Examples

=GetFileGroupVariableEnablement("Category", 1)

This example returns True if the Category variable is enabled for value 1, and False if it is not. The function is used within a file that belongs to a file group, so the file group ID is omitted.

=GetFileGroupVariableEnablement("Category", Variables!$F$27, Variables!$F$10)

This example is the same as the previous example, except that the enablement value and the file group ID are being read from another sheet using a cell reference. In most cases these values will be queried into the file using a GetData data lookup or function.