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