You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OBI - Submit to Hire Ratio

Received Response
39
Views
9
Comments
edited Jun 23, 2016 6:33PM in Reporting and Analytics Taleo Enterprise 9 comments

Summary

Help with calculating the # Submits(Presented) per Hire for each Filled Red and showing as a Ratio

Content

We have these formulas for calculating the # Submitted to a HM and the # Offers Accepted.  They are each showing as a column in the report.  Can you help me show a third column that divides the two and shows as a ratio?  I've seen percentages formulas, but cannot find anything on ratio.

count(distinct case when "Submission CSW Status - Historical"."Historical Status Name"  = 'Presented' then "Submission General Info"."Submission Identifier" end) / count(distinct case when "Submission CSW Status - Historical"."Historical Status Name" = 'Accepted' then "Submission General Info"."Submission Identifier" end)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!