Filter Multiple Value Fields in View
Posted on 2006-03-28
Hi Experts: I have a question regarding views with multiple value fields. I have three fields on my form, Job1, Job2, Job3. I have a computed multiple value field called Jobs with formula Job1: Job2: Job3. I have created a view that has Jobs as a column, and have checked the "Show multiple values as separate entries", so I get an 3 entries on my view.
Problem is that it is possible for one or more jobs to be blank, in which case I do not want them to show up on the view. How can I go about filtering out the blank ones?