Constants

The rules syntax supports different kinds of constants.

These rules apply to constants:

  • Numeric. For example:

    [PROFIT:'Gross Margin in percent'] = [PROFIT:'Gross Margin'] / [PROFIT:'Revenue'] * 100

    The decimal separator is always a point, no matter what the regional settings may indicate. Commas must not be used as thousands separators.

  • Strings: They must be enclosed in single or double straight quotes.
  • #NA: Simulates an empty cell. For example:

    [ ] = #NA