Forum Discussion

negbc's avatar
negbc
Helper II
1 year ago
Solved

Multiple Operators in Conditional Query

I have the code below that is returning the incorrect result. I believe it is the multiple 'or' conditions afterwards. Is there a solution to fix this so the result would be if the Line=ele AND ship=VA AND Category is any of the following then the result is cust whse. Or at least a better understanding of how this would be enterpreted? 

 

if [Line]="ELE" and [Ship]="VA" and [Category]=101 or [Category]=102 or [Category]=103 or [Category]=104 or [Category]=105 or [Category]=106 or [Category]=107 or [Category]=108 or [Category]=109 or [Category]=110
then [Cust]

 

Thanks!

  • Anonymous's avatar
    Anonymous
    1 year ago

    if ([Line]="ELE" and [Ship]="VA") and ([Category]=101 or [Category]=102 or [Category]=103 or [Category]=104 or [Category]=105 or [Category]=106 or [Category]=107 or [Category]=108 or [Category]=109 or [Category]=110)
    then [Cust] else null

     

    --Nate

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    if ([Line]="ELE" and [Ship]="VA") and ([Category]=101 or [Category]=102 or [Category]=103 or [Category]=104 or [Category]=105 or [Category]=106 or [Category]=107 or [Category]=108 or [Category]=109 or [Category]=110)
    then [Cust] else null

     

    --Nate

    • negbc's avatar
      negbc
      Helper II

      Parentheses, of course! Thanks!