Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a three field empname, year, permossion and i want a name of emp whose permossion flag is false for all three year.
try the exp below.
Concat(Aggr(If(Count(Distinct {<permossion={'false'}>} year)>2,empname), empname), ',')
i didn't checked the result of it
Try this
Concat({<permossion={'false'}>} empname, ',')
i want a emp name whose permossion flag is false for all three year
try the exp below.
Concat(Aggr(If(Count(Distinct {<permossion={'false'}>} year)>2,empname), empname), ',')
i didn't checked the result of it