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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Case syntax errors
I have a case syntax error I need help with. Below is the formula. If I remove all of the case syntax, the SUM formula works on its own. But when I add the case I get syntax error. Checked spelling and adding in " and ' with no luck. Even tried case when {type} in (Work Order Completion) to see if it was getting caught up on multi select but no luck.
CASE WHEN {type}
IN (Assembly Build, Assembly Unbuild, Transfer, Transfer Order, Item Fulfillment, Item Receipt, Vendor Return Authorization, Work Order Completion, Work Order Issue, Inventory Adjustment)
THEN
SUM {quantity} OVER(PARTITION BY {item} ORDER BY {trandate})
Tagged:
0