Percent of total - Values

[JDong]

Hi Team,

I need to calculate the percentage value for 2 columns

Closed	Open	Closed %	Won %
0	1
0	1
0	1
0	0
0	0
1	1
0	1
0	1
1	0
1	0

How can I get the results for Closed% and Won% in the above table ? 

Thanks

[Emil_Kos · Accepted solution]

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!

[atcodedog05]

Hi @JDong 

Here is a workflow for the task.

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 😀👍

[atcodedog05]

Interesting, now you have 2 different approaches @JDong 🙂

[JDong]

Thanks 🙂

[JDong]

@Emil_Kos @atcodedog05 

One additional question.

What if I need to calculate SUM(Closed)/Sum(Won)

Where sum of Closed or Won would be the count of 1 in the dataset ?

Closed	Open	%
0	1
0	1
0	1
0	0
0	0
1	1
0	1
0	1
1	0
1	0

Thanks

[Emil_Kos · Accepted solution]

Hi,

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. 

[atcodedog05]

Hi @JDong 

Added a little bit of formatting to my previous one 😅

Here is a workflow for the task.

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 😀👍

[atcodedog05]

Guess i understood the requirement wrong again, sorry😅

[JDong]

@Emil_Kos @atcodedog05 

Thanks a lot to both of you !

one more question.

Fruits	Closed	Open	%
Grapes	0	1
Apple	0	1
Apple	0	1
Apple	0	0
Pear	0	0
Grapes	1	1
Grapes	0	1
Grapes	0	1
Pear	1	0
Pear	1	0

Is there a kind of LOD calulation in Alteryx. The values for % are currently constant, but is there a way they can change if we have a filter for the Fruits column ?

So the percentage would be different based on the fruit I filter on.

Thanks !