https://netsuiteprofessionals.com logo
#suiteanalytics
Title
# suiteanalytics
k

KnotKnick

03/24/2022, 2:03 PM
Hello! How can I run a search to pull all data that has a value which is not an integer in a certain field?
g

George McMullen

03/24/2022, 4:13 PM
You mean checking if a number is something like 4.25 vs. 4? Maybe you could add a formula in criteria such as:
CASE WHEN {fieldname} != TRUNC({fieldname}) THEN 1 ELSE 0 END
And then set the criteria for 1. The conversion to integer using TRUNC might not work all the time, but you could also try TO_NUMBER or CAST.
k

KnotKnick

03/24/2022, 5:03 PM
I have a custom field for tracking numbers which is populated by the EDI. the tracking number values should only be alpha-numeric, I want to get all those records that have anything other than tracking number. Sorry my initial request was not accurate. I thought tracking numbers were only integers, but looks like characters could be there as well.