Forum Discussion
IF OR Statement
Hello,
I have a pretty simple question. I am using Query editor to add a Custom column to my table. This column is called "True cost" and adjusts costs based on the Warehouse code by a factor of 2.5. When I use one warehouse code everything works fine, when I add 2 or more the logic doesn't work. I don't receive a syntax error but when the query runs, a following message comes up "The name OR was not recognized". What am I doing wrong and how to correctly make IF OR statement ?
This formula works = if [Warehouse Code] ="XXX" then ([Total Transacted Cost]/2.5) else [Total Transacted Cost]
This formula doesn't =if [Warehouse Code] =OR("XXX", "YYY", "ZZZ") then ([Total Transacted Cost]/2.5) else [Total Transacted Cost]
Thanks,
Andrey
Thanks. Looks like it worked. I just need to repeat each time [Warehouse Code] = before "or".
3 Replies
- Ashish_MathurSuper User
Hi,
Try this M code
=if [Warehouse Code] = "XXX" or "YYY" or "ZZZ" then [Total Transacted Cost]/2.5 else [Total Transacted Cost]
Hope this helps.
- Andrey28Regular Visitor
Thanks. Looks like it worked. I just need to repeat each time [Warehouse Code] = before "or".
- Ashish_MathurSuper User
Yes, i missed that. You are welcome.