Forums › Cached › Customization › Searches / List Views

This topic contains 1 reply, has 0 voices, and was last updated by michoel 8 years, 8 months ago.

  • Author
    Posts
  • February 8, 2016 at 4:26 pm #5358 Score: 0

    GarrettSulzman
    • Contributions: 0
    • Level 1
    • ☆

    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.

  • February 8, 2016 at 5:01 pm #5359 Score: 0

    michoel
    • Contributions: 0
    • Level 1
    • ☆

    The CASE statement should probably look like this:

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

  • Author
    Posts

You must be logged in to reply to this topic.