Hi, I am trying to display prices for two of the price levels in an Item Saved search.
Basically, I am trying to display unit price of Price Level 'Wholesale' in first column and unit price of Price Level 'Direct' in second column.
Can anyone take a look my below attempts at CASE and let me know how I can return the unitprice properly in an Item saved search?
Does not work: (Invalid Expression error)
CASE WHEN {pricing.pricelevel} = 'Wholesale' THEN {pricing.unitprice} ELSE 'No List Price Wholesale' END
partially works: (It displays the else part for items with decimal unit prices)
CASE WHEN {pricing.pricelevel} = 'Wholesale' THEN TO_CHAR({pricing.unitprice}) ELSE 'No List Price Wholesale' END