Custom Formulas
Discussion List
-
Count Distinct RequisitionsSummary Taking counts of reqs based on candidates step/statusContent I am trying to break down open requisition counts based on whether or not they have candidates in Re… -
Help With Onboarding FormulaSummary Onboarding Task completed formulaContent I was hoping someone could help me create a formula. Every time I try, I keep getting duplicate rows for each candidate … -
Help with a formula to capture # of career site postingsSummary Help with a formula to capture # of career site postingsContent Hello - I'm trying to create a few formulas to determine the following - How many requisitions ha… -
Case Statement including Date logic is not workingSummary I would like some help with an issue i'm having on a case statement using date logicContent Hi All, I'm looking for some guidance on an issue I'm having with a c… -
How to convert a text UDF to a number for use in a calculationSummary We have a UDF to capture the Commission amount and a UDF to capture the Total Target Comp for Sales offers. I want to calculate the commision split in OBI but it… -
Auditing Onboarding ProcessSummary Check if candidates have completed specified tasksContent The attached catalog is based on transitions processes configured in my zone. To use this analysis in y…Rachel Martorelli-Oracle 206 views 2 comments 4 points Most recent by Christian Ray Taleo Enterprise -
Time to Fill calculationSummary How do you calculate time to fill for just business days - not calendar days?Content Hello, Is it possible to calculate Time to Fill for just calendar days (and … -
Formula help for # openings minus accepted offersSummary Formula help for # openings minus accepted offersContent Hello - I'd like to create a formula to show # of remaining openings minus accepted offers. I don't want…
-
OBI - Pulling max item for reportContent Hello, I am working on a recruiting report in OBI in which the system will pull multiple rows if the data is duplicated (or, there are several pieces of informat…Sarah Volckmann-10978 60 views 4 comments 0 points Most recent by Sarah Volckmann-10978 Taleo Enterprise -
Isolating motive on workflow Step/StatusSummary I would like to determine a formula to isolate the motive a particular step/status changeContent Hi, I've searched the forum and have seen some different variati…
-
Recreating Sub Query Filters in BO in OBISummary Need assistance recreating a General Profiles Only report using a sub query filterContent Can someone help me rebuild the pictured query in OBI? Or suggest a bet…
-
Question regarding building a report using the "Reviewed Date" with multiple "Reviewed" reference moContent I am trying to build a report that will effectively show the time frame from which a candidate was shared with a Hiring Manager to when a decision was made to ei…
-
Handling NULL values in calculationsSummary Summing columns in OBI that contain NULL values results in a NULL sumContent Does anyone know how to handle NULL values as part of a calculation? I have columns … -
Converting Custom Variables/Formulas from BO to OBIEESummary Looking to convert custom variables/formulas from Business Objects to OBIEE.Content Hello Reporting and Analytics group members! Penske is currently in the proce…
-
% Of Submissions Passed through Steps in CSWSummary This is an example report that shows the percentage of submissions that have passed through various CSW Steps.Content The attached report highlights the use of t…
-
Recreate of MEASURES from Business Objects to Business Intelligence.Summary We created several measures in BO but cannot do this in OBIEEContent Can someone help me with a formula/sql to put on my column or a filter? We have tried the di…