IF list item 'x' THEN 'do this' ELSE...
I am trying to do an IF statement within a module dimensionalised by a List ('Volumes') which has 2 members: Retails and Wholesales.
I need to do a particular calculation depending on if the 'Volumes' are Retails or Wholesales.
I have tried IF Volumes.Retails THEN x ELSE y but this not work, giving the following error message:
The formula for 'XP 05 Derivative Mix'.Mix is invalid:
First argument for 'IF' function must have BOOLEAN format not LIST:Volumes
Can anyone help / advise?