Hello,
How can i resolve this expression?
Thanks
AND([situacao]=โAtivoโ,IN(USERSETTINGS(โฆ),elementos[agrupamento])) Translate
@Aleksi_Alkio thanks but doesnโt work.
Glad you found the solution!
What is the result or error?
When you are using the value from the USERSETTINGS table, you should add that field name as well. The alert is asking that field name.
@Aleksi_Alkio ok, but i want to list the rows from one table that contains the same value of the USERSETTINGS value.
how can i do that?
Okayโฆ AND([situacao]=โAtivoโ,USERSETTINGS(โฆ)=[agrupamento])
@Aleksi_Alkio thanks but i donยดt get that.
May I ask what is the problem with my above formula? What is the goal for this formula? With that formula, it will show you all rows in a slice when both of those evaluations are true.
@Aleksi_Alkio Thanks, it works. On USERSETTINGS(โฆ) missing USERSETTINGs(Agrupamento).
The correct is AND([situaรงรฃo]=โAtivoโ, USERSETTINGS(Agrupamento)=[agrupamento])
Thanks again
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |