Hi Team,
I need to calculate the percentage value for 2 columns
How can I get the results for Closed% and Won% in the above table ?
Thanks
Hi,
I wasn't sure what is the expected output but I have prepared something for you:
This is the workflow:
Unfortunately Alteryx don't have an easy tool in order to do this.
Append formula is really good to add information about sum of won/closed + amount of all lines to all the rows that you got.
I have attached a workflow. Please let me know if this is something helpful and if it is please mark my post as a solution.
Good Luck!
I believe you need to use this formula:
([Sum_Closed]+[Sum_Open])/[Count]*100
I have simplified my workflow as the previous solution provided by @atcodedog05 was better.
Hi @JDong
Is this what you are looking for?
Here is a workflow for the task. If not provide an expected output i can help out🙂
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Here is a workflow for the task.
