Alteryx Countif function

[jpatel3868]

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

[AngelosPachis]

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.

Hope that helps,

Angelos

[Qiu]

@jpatel3868 
Hope this will help.

[Tyro_abc]

Hi

This is my solution