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,