Forum Discussion

Andrey28's avatar
Andrey28
Regular Visitor
6 years ago
Solved

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 ...
Need Help
  • Andrey28's avatar
    Andrey28
    6 years ago

    Thanks. Looks like it worked. I just need to repeat each time [Warehouse Code] = before "or".

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

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.

Andrey28's avatar
Andrey28
Regular Visitor
6 years ago

Thanks. Looks like it worked. I just need to repeat each time [Warehouse Code] = before "or".

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    Yes, i missed that.  You are welcome.