Null Values in Parameter

[Khanson82]

I have this in my select expert:

(({?Members} = 'Yes' and {command.members} > 0) or ({?Members} = 'No' and isnull({command.members})))

The parameter only has a choice of Yes or No to the User..Yes being members with 1+ in the field.No being members with a null value.. My problem is when you choose both es and no or just no, I need it to pull records where the command.members is null.. Any ideas?? Thanks again!


CRXI

 

[Khanson82]

Figured it out..Just made two extra formula fields.. one that took the member field and made all null values show as 0 by converting to string....Then used another formula field to convert back to number, so I could format correctly..Then used:


(({?Members} = 'Yes' and ({@members2}) > 0) or (({?Members}) = 'No' and ({@members2}=0) ))

Worked great...