Create a Countif so I can filter on the values later in my Workflow

[Karl_Spratt]

Hi Community,

I want to to Create a Countif so I can filter on the values later in my Workflow, my scenario is 

I have customer bookings, which I have gotten into year / period view, in excel I'd write the countif as

=COUNTIF(D2:O2~">0")

then I would create another formula to say  if the countif was >= 4 say Yes i want to FC this Item, use its bookings.

FC Filter Formula

=IF(P2>=4~"FC = Yes"~"FC = No")

How do I create a countif / filter in Alteryx, can some please explain, also my monthly headers need to be dynamic, as we move into 2022 bookings data which will be sent to the WF with 2021 ( My look back is the last 12 moths rolling)

Attaching sample data, any help is appreciated.

TIA,

KArl.  

[atcodedog05 · Accepted solution]

Hi @Karl_Spratt 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @Karl_Spratt 

Cheers and have a nice day!