IF list item 'x' THEN 'do this' ELSE...

Options
Riccardo
Riccardo Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
in Planning & Modeling

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?

 

 

Thanks

Tagged:

Comments

  • Riccardo
    Riccardo Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
    Super, thanks for the quick reply!
  • Riccardo
    Riccardo Member, ALL USERS, Community Member Posts: 4 Occasional Contributor
    Thanks all, good points. This list is fixed and so hardcoding should not be an issue, but noted your points on best practice.

Categories