Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Percentage Calculation — Cloud Customer Connect
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

Percentage Calculation

Accepted answer
58
Views
3
Comments
edited Mar 1, 2017 9:11PM in Reporting and Analytics Taleo Enterprise 3 comments

Summary

Trying to write a formula to get me a percentage calculation

Content

The percentages I am trying to accomplish are two columns below:
 

Historical Step 2

#Submissions Complete

% of applications of Total completed

% of the step above

1.Submissions

 

100

 

 

  1. Interview Step

60

60%

 60%

  1. Offer Step

25

25%

 41%

  1. Post Offer Step

15

15%

 60%

  1. hired

10

10%

 66.6%

the fields that I am using are

Historical Step Bins are as below

CASE  WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'New' AND "Submission CSW Status - Historical"."Historical Workflow Name" <> 'Quad Pipeline Hire / Temp-to-Hire' THEN '1. Submissions' WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Interviews' THEN '2. Interviews Step' WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Offer' THEN '3.Offer Step' WHEN "Submission CSW Status - Historical"."Historical Step Name" = 'Post-Offer Checks' THEN '4.Post Offer Step' WHEN "Submission CSW Status - Current"."Current Reference Status Name" = 'Hired' THEN '5. Hired' END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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