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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

calcul division , result wrong OTBI

edited Mar 21, 2018 10:11AM in Reporting and Analytics for HCM 8 comments

Summary

result of Division of sum (measure ) /sum(measure ) is not good

Content

Hello ,

I want to calculate the percentage of headcount by competency

So I have the number of Headcount by competency  exemple 999 and the total headcount is 6082 > I want to divide 999/6082 .

In my request I put :  

round (sum ("Workforce Profiles - Person Profile Real Time"."- Person Profile"."Count of Profiles"  by "Workforce Profiles - Person Profile Real Time"."- Competencies"."Competency") / sum ("Workforce Profiles - Person Profile Real Time"."- Person Profile"."Count of Profiles") ,4) 

 

the result for this  row ; 0.0458  

It is incorrect .

Any helps please?

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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