Recruiting Perf Tiles - % calc help — 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

Recruiting Perf Tiles - % calc help

edited Jun 8, 2017 9:03PM in Reporting and Analytics for HCM

Summary

Recruiting Perf Tiles - % calc help

Content

HI

I used the sample performance tiles and they are great. However when I do the math for the % the sample formula does not equal the actual calculated amount.

Example: % Submissions Reviewed....I have a total of 4779 submission and 412 in review...the % to total should be 8.62% (412/4779)  but using the sample formula I get 7.79%

here is the formula from the sample w our company factors included...how do I get it to the right outcome of 8.62

cast(count (distinct case when    "Submission CSW Status - Historical"."Historical Status Name"   like '%Phone%' then  "Submission General Info"."Submission Identifier" end ) /   "Candidate Counts"."# Submissions" as double) *100

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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