STET

The STET function cancels the effect of a rule for a particular element.

This is a rules function, valid only in Planning Analytics rules. This function cannot be used in TurboIntegrator processes.

Syntax

STET

Arguments

None.

Example

In this example, the rule dictates that the value for Sales is always 100, except for the intersection of Sales and the element France from the Region dimension.

['Sales'] = IF(!Region @= 'France',STET, 100);