Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Case Statement Gone Wrong
Hi,
I have built a case statement but it works. However I want to modify it and create another concat but its bringing up a invalid expression error.
CASE
WHEN {custitem_bb1_wasprice}={custitemcustitem_price_vat} THEN ''
WHEN {custitem_bb1_wasprice}<{custitemcustitem_price_vat} THEN ''
WHEN {custitem_bb1_wasprice} IS NULL THEN ''
ELSE (CONCAT(CONCAT('Was £', {custitem_bb1_wasprice})|(CONCAT(CONCAT('Was £', {custitem_bb1_wasprice})|CONCAT( ' Save £', {custitem_bb1_wasprice}-{custitemcustitem_price_vat})))))
END
Please can someone help?
Thanks
Mayur
-- Never Mind,
Got it working
0