STET

The STET function is used to cancel the effect of a following rule. For example, if you have a rule written in this form:

['Revenue'] = [Units] * [Price]

If you want Revenue to remain manually editable for Germany, you can deactivate the rule for Germany by writing an additional rule that must be in front of the rule which is to be partially deactivated:

['Revenue', 'Germany'] = STET

If you use STET in connection with an accelerator, STET principally refers to the actual value of the current recalculated cell. If you activate an accelerator which affects a rule used by STET, you must write another accelerator for those cells affected by STET.

The alternative syntax, STET( ), is no longer supported.

Example

Cube Sales

['Revenue'] = IF(['Units'] <> 0, ['Units'] * ['Price'], STET)

must have these accelerators:

SALES['Units'] > ['Margin']

SALES['Margin'] > ['Margin']