[jmessersmith]

I have a field that starts out blank but gets data filled in after a while, I want to make a search where the empty field records appear at the top of the sort. Can that be done?
This is a cached copy. Click here to see the original post.

[JCirocco]

Just a guess but how about including a formula field with a case statement replacing the empty field with the lowest possible ASCII printable character (! I think) and then do the sort on the formula field?

CASE WHEN {fieldname} =” THEN ‘!” ELSE {fieldname}

---

JCirocco replied on 09/06/2016, 02:59 PM: I had typo on then where after ! is a double quote

[jmessersmith]

empty quotes didnt work. It still shows up blank. even if I used LENGTH it shows up blank. Is there a null comparison? Is there documentation on all the formula functions?

[JCirocco]

Sorry, try

CASE WHEN {yourfieldname} IS NULL THEN ‘!’ ELSE {yourfieldname} END

[michoel]

Originally posted by jmessersmith

View Post

Is there documentation on all the formula functions?

Netsuite has some documentation here:

https://system.netsuite.com/app/help…_N2833020.html

Because Netsuite uses an Oracle database in the backend, referring to the Oracle documentation is helpful, as is putting the keyword “oracle” into your search queries..

http://docs.oracle.com/cd/B19306_01/…b14200/toc.htm

[jmessersmith]

the IS NULL got it, Thanks guys. Thanks for the docs also.

[Author]

Posts