Grouping logical statements within a function
I still haven't figured out the best way, and in some cases, a way at all, to do this. Here's the (non-working) example at hand:Case (not IsEmpty(price)and Left(inventoryID;3) = "DBN" or "IPU";"CD")
What I want here is for Left(inventoryID;3) = "DBN" or "IPU" to evaluate first, then have that result evaluate with not IsEmpty(price)and...
How do I make this happen?