I need to create a report that has avg no of candidates rejections per requisition, so need to count no of rejected candidates per requisition?
It depends on how your data is structured, but =Count([CandidateID]) In ([Requisition ID]) or similar should help.
This will vary, though, based on the objects in the context in which you present the data. For example, if you’re presenting it as a table with one row per Requisition, then =Count([Candidate ID]) as an extra column would do.
1 Like