Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
)
Worked perfectly for me, thanks Diego!