Filter BLANK fields to show only

[whimsical_data]

How can I only my BLANK fields to show. Its a text field for letter grades.

 

[lbass]

Use a selection formula like this:

Isnull({table.text}) or
Trim({table.text})=“”

Replace the quotes in the above formula with your own.

-LB

 

[kray4660]

Of course a IsNull check will only work correctly if the formula workshop is set for 'Default Values for Nulls'. Another way to check for an empty string is Len({table.text}) = 0

 

[lbass]

Just to clarify, I’m sure you meant to say “is NOT set for ‘default values for nulls’”. Also, the second clause that I suggested is the equivalent of using len()=0. The second clause would make the formula work regardless of the null setting.

-LB