Calculating the percentage of a column with different categories

[sriniprad08]

Hi Team,

I have an excel file containing the data with different column. I want to calculate the percentage of particular column with different categories. Say the column has 3 categories. Then it has to give me the total count and the percentage of each categories in the data.?

Any thoughts please?

Thanks 

Sriniv

[TheOC]

hi @sriniprad08 

I think i understand what you mean, to do this i would create a formula tool to calculate the total, and then divide the figure you want by this total figure. Can you upload a sample input and what you would like for an output, and i'd be happy to give this a go for you!

[sriniprad08]

Hi @TheOC 

Thank you for helping out. Please find attach the sample data and the solution

[RolandSchubert · Accepted solution]

Hi @sriniprad08 ,

there are different approaches to create this output, e.g. Summarize, Append Fields and Formula tools can be used.

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[TheOC · Accepted solution]

hi @sriniprad08 

I have created a workflow that makes this for you:

Bare in mind the percentage is slightly inaccurate as its to 1 decimal place as you requested in your output. This can easy be changed in the formula tool however.

Please find attached the workflow, and let me know if i can help any further!

[sriniprad08]

Hi @TheOC 

Thank you so much . Really appreciate your help. I have one question actually i am want the percentage of column A. But i can see in your workflow percentage is calculated for column C. Am i missing something?

Cheers,

Sriniv

[sriniprad08]

hi @RolandSchubert 

Thank you so much. its helpful and worked. However i have a question in case if i don't have the column C and i need to calculate the percentage of column A what changes i should have done to the workflow?

Cheers,

Sriniv

[TheOC]

@sriniprad08 

OOPS!

I had thought you wanted an average of Column C!

Easy fix:

Attached a fixed solution!

Have a great day, and let me know if i can help any further!

[sriniprad08]

Hi @TheOC 

Thank you so much. It works perfectly. However when i tried to run with my sample data its not. I don't have an amount column which we can sum . i have something like this . How can i modify the workflow?

Sample
A	B
R	s
G	s
G	t
R	t
X	t

[RolandSchubert · Accepted solution]

If I got you right, you want the share of "count"?  I've modified the workflow a bit.