General considerations
Here is additional information about bypassing rules.
- The rules syntax is not case-sensitive. You can use both uppercase and lowercase letters.
- You can use spaces within rules to improve clarity.
- A rules statement can occupy one or more lines in the Rules Editor. It can also contain one or more formulas. End each statement with a semicolon.
- To add comments and to exclude statements from processing, insert the number sign at the
beginning of a line or statement. For example:
#The following rule is not active # ['Gross Margin']=['Sales']*0.53;
The length of a comment line is limited to 255 bytes. For comments longer than 255 bytes, you must break up the comment into multiple lines, with each one including the number sign, #, at the beginning.
Note: For Western character sets, such as English, a single character is represented by a single byte, allowing you to enter comments with 255 characters. However, large character sets, such as Chinese, Japanese, and Korean, use multiple bytes to represent one character. In this case, the 255 byte limit may be exceeded sooner and not actually allow the entry of 255 characters.