Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I filter out data using an expression with multiple conditions?

udles5666
8 - Asteroid

Hi community,

I want to filter out data using an expression with multiple conditions in the attached but, not sure how can i do that? 

Tried IF statement but didn't work. Can someone please help in filtering out the data for below conditions? Attached for reference.

Thanks in advance. 

 

IF 

[Fiscal year] = "2020"
AND [Fiscal year/period] = "P12"
AND [Cost Element] = "Salaries - Ordinary"

 

2 REPLIES 2
grazitti_sapna
17 - Castor

Hi @udles5666 , try using this.

grazitti_sapna_1-1595998093859.png

Thanks.

Sapna Gupta
udles5666
8 - Asteroid

Hi .@

 

 

 

Labels
Top Solution Authors