Custom Formulas
Discussion List
-
Return only the most recent General Profile- OBISummary Looking for a formula to return the most recently created profileContent Hello, I am having issues reporting on General Profiles. I am using all candidate fields… -
Req. Saved as Open Date and ageing weekSummary Req. Saved as Open Date and ageing week calculationContent Hi there, I am create an average time to fill report and I have added all fields except two fields tha… -
Reporting on a "As Of" Date - Any Suggestions?Summary Trying to leverage an existing data field/derived field to calculate an as of date to report on historical data and get a snapshot of data at a point in time.Con… -
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 205 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 59 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…