Syntax

Member formula expressions support functions and variables. Follow these syntax rules for functions and variables when you create formula expressions:

• Enclose variables or properties with square brackets, [ ]. If you omit square brackets, the variable is treated as a native variable.

• Enclose member names with quotation marks.

• Characters in variables are case-insensitive, but can't have extra spaces or characters such as underscore ( _ ).

• You can include subcalls to other functions within an expression.

• Don't enter text where a number is required.

• The order of the outline is important in a member formula. For example, don't reference a value that has not been calculated yet.