Alteryx Countif function

Question

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

Tyro_abc · Answer

Hi

This is my solution

Count Bid Ask.yxmd

Qiu · Answer

@jpatel3868 
Hope this will help.

1201-nvallem.yxmd

AngelosPachis · Answer

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

sample_workflow.yxmd