Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Filtering Unit Price by Price Level
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?