Hi Team, I need to calculate the percentage value for 2 columns ClosedOpenClosed %Won %01 01 01 00 00 11 01 01 10 10 How can I get the results for Closed% and Won% in the above table ? Thanks

Percent of total - Values

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

Datasets

Developer

Accepted answers

Emil_Kos

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!

Percent.yxmd

Emil_Kos

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.

Percent 2.yxmd

atcodedog05

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

Percent 2.yxmd

All comments

Emil_Kos

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!

Percent.yxmd

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

Percentage.yxmd

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

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.

Percent 2.yxmd

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

Percentage (1).yxmd

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 !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703