https://netsuiteprofessionals.com logo
n

neerajrtiwari

01/14/2017, 2:02 AM
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