yes, there's spacing, and I suppose there could po...
# suitescriptj
Jacob Jackson
11/13/2019, 7:15 PMyes, there's spacing, and I suppose there could potentially be NULL values
j
JohnnyC
11/13/2019, 7:19 PMThe else block you could try and wrap each field with NVL.. allows you to substitute a value when NULL is found example NVL({custrecord_qtylocationtrack},0)-NVL({custrecord_delivered_tally_qty},0)
e
Eric B
11/13/2019, 7:33 PMas well as TO_NUMBER() since you're doing math...
j
Jacob Jackson
11/13/2019, 7:35 PMstill cant get it to work, not sure why
s
stalbert
11/13/2019, 7:37 PMwhen expressions get complicated in search, I often tend to think of that as a sign to perhaps do some of the work in SuiteScript
j
Jacob Jackson
11/13/2019, 7:42 PMyea we are already down that road. this saved search is the basis of a suitelet that's going to be created to combine multiple searches. just trying to save some time in in the development phase.
s
stalbert
11/13/2019, 7:43 PMimho, saving time in the development phase working with searches = NFT 🙂