What's the best method of filtering customers who have a certain range of price levels. Simply using "None Of" is not sufficient, as it still pulls in the customer if they have ANY pricing level assigned to them. I tried a few formulas, but nothing has worked so far.
k
KevinJ of Kansas
10/06/2020, 6:52 PM
Use a case statement to return a 1 when they have that price level - then sum/max/min results looking for a 1 or 0 depending on if you want them included or excluded.
j
J-Mack
10/06/2020, 8:51 PM
Would this be on the criteria or results?
k
KevinJ of Kansas
10/06/2020, 10:13 PM
Criteria - but do it in results until you can identify that it's working correctly.