Hi,
I am trying to get a qualified percentage from the following data. Column "Step" always changes, as in, it can be shorter, longer, more or less "steps" can be in this column. I want to get a qualified percentage by dividing the "No data Entry Required" + "Entered in SE/Client ATS" / "sourced". The data is attached and
Any suggestions...
Step 7/29/2012 8/5/2012 8/12/2012 8/19/2012 8/26/2012 Total
Sourced 20 5 20 32 12 89
Sourced Candidate Submitted to CFR 8 0 20 8 7 43
No Data Entry Required 0 0 7 0 3 10
Entered in SE/Client ATS 0 8 0 0 0 8
Total 28 13 47 40 22 150
Bookmarks