Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm creating a list box from an expression that I'd like to be populated with the same values regardless of the selection. Somehow the set analysis qualifier {1} doesn't work.
=aggr(
//minstring({1<Role={"*"}>}
if(sum({1}TeamAllocation*ClientAllocation)>0,Role)
//)
,Role)
I tried using minstring as replacement for only(...) suggested elsewhere.
Any recommendations? Thanks!