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!
Saved Search Formula question
I have a saved search, a formula text fields, I had a formula as WHEN {name} = '12333' THEN '25' ELSE {locationquantityavailable}
Hope to achieve if item part number is 12333, then return 25, the fixed value, otherwise, return inventory location qty available value.
Can you advise where I can find the documents for formulas, descriptions about exact grammars for function like IF, WHEN.
Also, how to correct my formula since it is returning error?
Thank you,
Tagged:
0