Derivative logical operator issue
Trying to create simple rule based on value greater than or less than zero, however only my Negative rule successful.
A#[ACC1]=ACC1_POS | Create If > x | Final and A#[ACC1]=ACC1_NEG | Create If < x...
Got to the bottom of this with the help from Francisco (Curro) Tores of Inlumi.
The specific cube we are submitting into, was setup with specific Integration settings on some Scenario members, where it has 4 additional Attribute Value Dimensions.
On the Data Source config side, these fields had no reference associated with it, i.e. column number linked to an Amount. When specifying this detail, and then also flagging each field as False for 'Zero Suppresion', the derivative rules started working as expected.
