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.
Nested case when Statement
I am having trouble with a nested case when statement.
Basic outline of desired statement:
case
when
statementA = {name} then 'MATCH'
else 'No Match'
end
~~~~~~~~~~~~~~~~~
The part i need nested i statementA.
statementA needs to be:
case
when substr({name},4,1) = '-'
then substr({name},1,9)
else
rtrim({assemblyitembillofmaterials.billofmaterials},' BOM')
end
Jay Schwausch
P.R.I. - KACE Valves, NetSuite Administrator
Tagged:
0