How to calculate % of a subsection?

Hi,

In the attached workflow, I have created a summarize function which groupsby "BranchNumber", "PositionStatus" and counts the "PositionStatus" to display below:

Now, I want to be able to do the following: for each branch number, calculate Inactive Count / Total count of branch number

- For 10001: 1 (inactive) / 5 (total 10001 record) = 20%

- For 10002: 2 (inactive) / 5 (total 10002 record) = 40%

After getting this, I want to then create a table like following:

Please let me know the best way possible, thank you for the help

New Workflow2 - for forum.yxmd

alteryx example file.xlsx

Workflow

Transformation

Preparation

Accepted answers

Luke_C

Hi @johny9887

Something like this should do the trick - count the total records for each branch and join those back to calc the percentage

New Workflow2 - for forum.yxmd

All comments

Luke_C

Hi @johny9887

Something like this should do the trick - count the total records for each branch and join those back to calc the percentage

New Workflow2 - for forum.yxmd

johny9887

Hi, Thank you for your reply, one quick follow up question.

So is there a way to just select rows with the "Inactive" positionStatus?

Thank you

Luke_C

Hi @johny9887

Yes, you would use a filter tool. Here's the workflow with that added as well as a select to limit the columns to what is in your original post:

New Workflow2 - for forum.yxmd

johny9887

Thank you for the help, really appreciate it

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703