https://netsuiteprofessionals.com logo
Title
a

AJ Patel

03/23/2022, 8:04 PM
Any ideas for a formula to check if a Document Number/ID field is a number? I want to exclude any results from a saved search if the document number contains letters or is blank
a

AI1

03/23/2022, 9:20 PM
CASE WHEN {number} - 1 > 0 THEN 1 ELSE 0 END. is 1
a

AJ Patel

03/23/2022, 9:52 PM
Thanks! I had a datatype error so I added To_Number and that worked: CASE WHEN TO_NUMBER({number}) - 1 > 0 THEN 1 ELSE 0 END