# of Submission with Different Conditions
SummaryNeed Help with the design of formulas
Is it possible to create two data fields that calculate two different conditions? I am trying to calculate the % of total # of external female candidates who passed the first round of screening process, divided by the total count of "# of Job Submission Complete". The challenge is that I don't know how to make the second data filed, "total count of job submission, work as expected. Following is the example of what I would like to see it. Thank you for taking time to read my request.
Total # of external female candidate/ Total # of candidates = 38% (38/100)