Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
If I use this expression it works:
=aggr(MaxString ({$<databasename_YEAR={'$(=getfieldselections(databasename))'}>} Indikatorname_YEAR),Indikatorname_YEAR)
But if I use it in a IF function it does not work:
=if(GetSelectedCount(databasename) = 1,aggr(MaxString ({$<databasename_YEAR={'$(=getfieldselections(databasename))'}>} Indikatorname_YEAR),Indikatorname_YEAR),
if (GetSelectedCount(databasename_YEAR) = 1,Indikatorname_YEAR))
And have also tried the above in a if-then-else but with the same result.
Can anyone tell me why it does'nt work in the if function
Thanks
hmm ok I fixed it like this:
=aggr(MaxString ({$<databasename_YEAR={'$(=getfieldselections(databasename))', '$(=getfieldselections(databasename_YEAR))' }>} Indikatorname_YEAR),Indikatorname_YEAR)
but it still puzzle me why the if then did'nt work!
hmm ok I fixed it like this:
=aggr(MaxString ({$<databasename_YEAR={'$(=getfieldselections(databasename))', '$(=getfieldselections(databasename_YEAR))' }>} Indikatorname_YEAR),Indikatorname_YEAR)
but it still puzzle me why the if then did'nt work!