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
How can we apply calculation at column level in OTBI report
Summary:
We have a requirement to put condition at column level to find out requisition which has approved days greater than 60days.
EX- We have a report at dashboard, which pulling Job Family, current openenings and Average days open
Under each Job Family, we have a total number of requisition Ids. We need to add one more column and has to print how many requisitions has been opened more than 60days divide by total requsition under each Job Family
EX- Under Customer Family, we have total 11 Requsisition and suppose 4 out of 11 has been ceated more than 60 days.
So, we need to do calculation in new column = 4/11
Tagged:
0