How to calculate % of a subsection?

[johny9887]

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

[Luke_C · Accepted solution]

Hi @johny9887 

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

[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:

[johny9887]

Thank you for the help, really appreciate it