Hi,
I need a formula for the count. "A" Column has 12 transactions so i need the formula to find the count.
(In excel: =COUNT(A1:A12) result will be 12)
Regards,
Lalaiah
@Lalaiah
You could use a summarize tool with the count action, or use the count records tool. See attached workflow with examples of both. You can then join/append this data back into the workflow as needed.
Check out the Tool Mastery Index on the Transform Palate, Summarize Tool. There's also a "count records" tool on the Transform Palate.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593
Cant, we use a formula? because i need to insert the middle of the formula so.