Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
HCM OTBI: OTBI Report Calculations Issue
Hi,
I am facing an issue in OTBI which involves calculations. Please see the below example
Column 1: SUM(Distinct TIMESTAMPDIFF(sql_tsi_month, "Worker"."Person Start Date", "Worker"."Termination Date" )/12.0) - shows the result as 100.667
Column 2: count (distinct "Workforce Management - Worker Assignment Event Real Time"."Worker"."Employee List Name") - shows the result as 22
Column 3(Avg Tenure): 100.667/22 = 4.575(Expected result) but getting 4.511 when using column1/column2
Kindly help us on this
Thank you,
Chaitra
Tagged:
0