I'm receiving an unexpected error when I try to ru...
# suiteanalyticsn
NS.TX
10/15/2020, 6:20 PMI'm receiving an unexpected error when I try to run a search with the following formula:
case when {custitem_a} != 'NULL' AND {quantityonhand} = 'NULL' then ({custitem_a}-{custitem_b}) else X end
Can anyone help identify what is wrong with the formula, please? My own efforts have been unsuccessful.
NS.TX
10/15/2020, 6:24 PMMy objective is to leverage case statements to build priority logic for a calculation - when A is not empty but Y is empty, then subtract Z from A...
b
battk
10/15/2020, 6:26 PMDont compare numbers to strings
l
Luis
10/15/2020, 6:30 PMI don't put quotes between NULL. Maybe, that's (one of) the reason/s.
n
NS.TX
10/15/2020, 6:34 PM@battk I dont follow, can you elaborate?
b
battk
10/15/2020, 6:40 PMquantityonhand is a number
battk
10/15/2020, 6:40 PM'NULL' is a string
battk
10/15/2020, 6:40 PMits invalid to compare a string to a number
g
George McMullen
10/15/2020, 6:41 PMIS NOT NULL
👍 1
🤣 1
b
battk
10/15/2020, 6:42 PMn
NS.TX
10/15/2020, 6:43 PM@George McMullen I had just switched this and it appears to be working now - ty
👍 1
NS.TX
10/15/2020, 6:44 PM@battk ty for the clarification and the link.
g
George McMullen
10/15/2020, 7:17 PMI've done the same thing a million times. 🤣