Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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