Constants

Constants have these limitations:

• Numeric. For example:

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

  In all numerical representations, the decimal separator must be a decimal point (.), irrespective of regional settings. Digit group separators are not supported.

• Strings: They must be enclosed in single or double straight quotes.
• #NA: Simulates an empty cell. The rule in this example specifies that no value is returned for cells in the slice of the Price measure and Variance value type.

  [MEASURE:'Price', VALTYPE:'Variance'] = #NA