Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a conditional list box:
=if(Field1<10,Field2)
If I select values from this list box, the field with the conditional is also selected.
For example, if I select 31, for field 2, 2,3,5 are selected in Field1
But 31 in field 2 has more matches and I want to see all of those:
I read a post that implies I might be able to do this with set analysis, but I am struggling to write the set analysis.
Actually try this instead
=Aggr(Only({<Field1 = {"<10"}, Field2>} Field2), Field2)
Try this
Aggr(Only({<Field1 = {"<10"}>} Field2), Field2)
Actually try this instead
=Aggr(Only({<Field1 = {"<10"}, Field2>} Field2), Field2)
Thanks, I was missing the Aggr part, that makes sense.