Exclude a value if 2 conditions are met

[Daro68]

Hi There,

I'm trying to exclude a value if 2 conditions are met.

In the example you'll find a Value, VRA, Salesperson and a Result column. Obviously the result column is what I'm trying to achieve but I can't figure it out.

If the condition VRA=yes and Salesperson does not contain -KEY the value should be excluded from the column.

Can anyone help me with this one please?

Thank you so much.

D.

[amitchandak]

@Daro68 , Try a new column like

if(search("VRA",[VRA],,0) >0 && search("KEY",[salesperson],,0)<=0, "Yes", "No")

[Payeras_BI · Accepted solution]

Hi @Daro68 ,

Try with this calculated column

Regards,