Hello, How can i resolve this expression? ...

expressions
(Tiago Maciel) #1

Hello,

How can i resolve this expression?

Thanks

(Aleksi Alkio) #2

AND([situacao]=“Ativo”,IN(USERSETTINGS(…),elementos[agrupamento])) Translate

(Tiago Maciel) #3

@Aleksi_Alkio thanks but doesn’t work.

(Aleksi Alkio) #4

Glad you found the solution!

(Aleksi Alkio) #5

What is the result or error?

(Tiago Maciel) #6

@Aleksi_Alkio

(Aleksi Alkio) #7

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.

(Tiago Maciel) #8

@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?

(Aleksi Alkio) #9

Okay… AND([situacao]=“Ativo”,USERSETTINGS(…)=[agrupamento])

(Tiago Maciel) #10

@Aleksi_Alkio thanks but i don´t get that.

(Aleksi Alkio) #11

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.

(Tiago Maciel) #12

@Aleksi_Alkio Thanks, it works. On USERSETTINGS(…) missing USERSETTINGs(Agrupamento).

The correct is AND([situação]=“Ativo”, USERSETTINGS(Agrupamento)=[agrupamento])

Thanks again