Column_Names

When you create an expression, refer to columns using their column names.

Note: If a column is used in an expression, then the expression is said to have a dependency on that column. If a dependent column is renamed or removed, no exception is thrown. An exception will be thrown when the now-broken expression column is accessed.

When you create an expression for a filter, enclose strings with single quotation marks:

LastName = 'Jones'

If a column name contains any non-alphanumeric characters or starts with a digit or matches (case-insensitively) any of the following reserved words, it requires special handling, as described in the following paragraphs.

And, Between, Child, False, In, Is, Like, Not, Null, Or, Parent, True

If a column name satisfies one of the above conditions, it must be wrapped in either square brackets or the ` (grave accent) quotes. For example, to use a column named Column# in an expression, you would write either [Column#]

Total * [Column#]

or `Column#`

Total * `Column#`

If the column name is enclosed in square brackets, then any ] and \ characters (but not any other characters) in it must be escaped by prepending them with the backslash (\) character. If the column name is enclosed in grave accent characters then it must not contain any grave accent characters in it. For example, a column named Column[]\ would be written:

Total * [Column[\]\\]

Total * `Column[]\`