In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
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
Hi
This is my solution
