## 3.14.24  Syntax for Entering Values
Follow these syntax rules when you enter members for filtering and values for prompting in macros.
For compounded dimensions, the complete compounded key of the member must be used.
| Description                                           | Example   |
|-------------------------------------------------------|-----------|
| Equal to                                              | 15        |
| Exclude value                                         | !22       |
| Value range                                           | 1 - 5     |
| Exclude value range                                   | !6 - 9    |
| Greater than                                          | >8        |
| Exclude values greater than <value limit>             | !>8       |
| Greater than or equal to                              | >=8       |
| Exclude values greater than or equal to <value limit> | !>=8      |
| Description                                                                              | Example                                                                                                                                      |
|------------------------------------------------------------------------------------------|----------------------------------------------------------------------------------------------------------------------------------------------|
| Less than                                                                                | <12                                                                                                                                          |
| Exclude values less than <value limit>                                                   | !<12                                                                                                                                         |
| Less than or equal to                                                                    | <=12                                                                                                                                         |
| Exclude values less than or equal to <value limit>                                       | !<=12                                                                                                                                        |
| Contains pattern (for example, all values that begin with A)*                            | A*                                                                                                                                           |
| Exclude values that contain pattern (for example, exclude all values that begin with A)* | !A*                                                                                                                                          |
| Dimension hierarchy node                                                                 | +<Dimension Attribute>(<Technical Nameof Dimension>) For example: +ELEMENT1(WBS_ELEMENT)                                                     |
| Text hierarchy node                                                                      | +<Technical Nameof Hierarchy Node>(0HIER_NODE) For example: +EUROPE(0HIER_NODE)                                                              |
| Delimiter for multiple values; semicolon followed by a space                             | 1-5; >12; !8                                                                                                                                 |
| Multiple values may also be passed as an array of strings                                | 1-5 >12 !8                                                                                                                                   |
| Escape character; backslash without space                                                | \ If you enter a string that contains one of the special characters used in these syntax rules, you can use a backslash as escape character. |
*You cannot use these syntax rules for filtering.