Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Recruiting Perf Tiles - % calc help
Summary
Recruiting Perf Tiles - % calc helpContent
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:
0