Percentage Calculation
Summary
Trying to write a formula to get me a percentage calculationContent
The percentages I am trying to accomplish are two columns below:
|
Historical Step 2 |
#Submissions Complete |
% of applications of Total completed |
% of the step above |
|
1.Submissions
|
100 |
|
|
|
60 |
60% |
60% |
|
25 |
25% |
41% |
|
15 |
15% |
60% |
|
10 |
10% |
66.6% |
the fields that I am using are
Historical Step Bins are as below
CASE WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'New' AND "Submission CSW Status - Historical"."Historical Workflow Name" <> 'Quad Pipeline Hire / Temp-to-Hire' THEN '1. Submissions' WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Interviews' THEN '2. Interviews Step' WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Offer' THEN '3.Offer Step' WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Post-Offer Checks' THEN '4.Post Offer Step' WHEN "Submission CSW Status - Current"."Current Reference Status Name" = 'Hired' THEN '5. Hired' END