[GarrettSulzman]

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?
This is a cached copy. Click here to see the original post.

[michoel]

The CASE statement should probably look like this:

Code:
CASE WHEN {pricing.pricelevel} = “Market Price” THEN {pricing.unitprice} ELSE 0 END

[Author]

Posts