Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Alteryx Countif function

jpatel3868
7 - Meteor

I need a Countif function that counts 1 everytime theres a bid and ask . For example, AAPl has 2 because it has two bid ask spreads.  

 

MSFT has 1 because its missing an ask for one of them.

 

 

At the end I want a total of how many broker quotes. 

 

Tried using the formula tool but getting parsing errors

Screen Shot 2021-11-30 at 3.31.46 PM.png

3 REPLIES 3
AngelosPachis
16 - Nebula

Hi @jpatel3868 ,

 

One way would be to transpose the data and group by the ticker field. Split the headers on the "." to get the broker acronym and then count them with a summarize tool. Since you are looking for pairs of bid and ask, you can divide by 2 to get the total number of broker quotes.

 

AngelosPachis_0-1638313547792.png

Hope that helps,

Angelos

Qiu
21 - Polaris
21 - Polaris

@jpatel3868 
Hope this will help.

1201-nvallem.PNG

Tyro_abc
11 - Bolide

Hi

 

This is my solution

 

Tyro_abc_0-1638328491616.png

 

Labels
Top Solution Authors