I'm building a Saved Search that needs to filter out the Unit Price on a single Price Level. I will be replicating this based on the Price Level in the Filter Section. I can get the list of Prices Using the "Other Prices" field; however, I'm wanting the following:
{pricing.unitprice} WHERE {pricing.pricelevel} = "Market Price"
I know this should be a CASE statement, but I am not getting any results.
CASE {pricing.unitprice} WHEN {pricing.pricelevel} = "Market Price" END
What am I missing?