Set Analysis to disregard all selections except one field

[#1]

Hi,

In a table, I want to show the result of a count function together with the same function disregarding ALL selection except one (PostalCode). The code below works fine for a written list of values, but when I try to generalize it to use selcted values instead I doesn't got any result. Why?

=Count(
{1<PostalCode={14652,14654}>}
// {1<PostalCode={$(=getfieldselections(PostalCode))}>}
ID_Index)

Any hint?

/Martin Höglund

[#2]

Hi Martin,

try this:

=sum(
{1< // Disregards all selections with 1
PostalCode=P(PostalCode) // Using element function P() to select the Possible values for Year (this will work with Null(), 1 and many values selected in the field)
>}
Amount // Whatever you wanna measure
)

[#3]

Worked perfectly for me, thanks Diego!