OBI - Submit to Hire Ratio
Summary
Help with calculating the # Submits(Presented) per Hire for each Filled Red and showing as a RatioContent
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)
0