This content has been marked as final.
Show 2 replies
-
1. Re: How to eliminate Null values
Shawn Wallwork Sep 29, 2012 3:57 PM (in response to Philip George)Philip, there are different ways of doing this, but here's one that's fairly easy:
1. Duplicate the 'Job' field (this creates a calculated field with [Job] in it)
2. Put the 'Job (copy)' on the filter shelf
3. Edit the filter to exclude the Null
4. Put the original 'Job' field on the filter shelf
5. Show the Quick Filter
6. Click the triangle on the Quick Filter and select 'Only Relevant Values'
The Nulls disappear.
--Shawn
-
2. Re: How to eliminate Null values
Philip George Sep 29, 2012 11:27 PM (in response to Shawn Wallwork)Thanks shawn for the help