Rules Processing

Hi,

We have the below measures of which all are editable except LY Sls U:

Sls Ratio (agg method - recalc)

Sls U (agg method - total)

Last Week Sls U (agg method - total)

Sls U v LY (agg method - recalc)

LY Sls U (agg method - total)

The corresponding rules are:

Rule1:

Last Week Sls U = lag(Sls U)

Rule2:

Sls U = Sls Ratio * Last Week Sls U

Sls Ratio = Sls U/Last Week Sls U

Rule 3:

Sls U v LY = Sls U - LY Sls U / LY Sls U

Sls U = ( Sls U v LY * LY Sls U) + LY Sls U