Create a Button which can include Null value

[#1]

Hi all,

I did some search online but cannot come to a way to include Null Value in the selection.

The thing I need to do: I am going to create a button which make a variable A exclude a particular value a1. However A has some NULL value in the record, I need to keep these records.

Could anyone help me out on this problem?

Thank you

[swuehl · Accepted solution]

Have a look at

Excluding values in Set Analysis

You would need to identify a key field (or create a new field in the script), then the set expression might look like

=Sum({1<KeyField = e({$<A = {a1}>}) >}Value)

If you need to create a button Selection - Select in field action, then use the KeyField as field to select in and something like

='=Sum({1<KeyField = e({$<A = {a1}>}) >} 1)'

as search string