`CASE WHEN {pricing.pricelevel} = 'MSRP' THEN NVL(...
# generalj
jcribb
06/12/2018, 2:42 PMCASE WHEN {pricing.pricelevel} = 'MSRP' THEN NVL({unitprice},0)-NVL({shipping_cost},0) ELSE {unitprice} ENDjcribb
06/12/2018, 2:42 PMCASE WHEN {pricing.pricelevel} = 'MSRP' THEN NVL({unitprice},0)-NVL({shipping_cost},0) ELSE {unitprice} END