Custom Formulas
Discussion List
-
Formula Help - Pulling data since beginning of yearSummary Writing formula to display results that only coincide with current yearContent Hello, I am creating a report that should only pull the candidates that have been …User_2025-01-23-22-24-54-342 57 views 6 comments 0 points Most recent by User_2025-01-23-22-24-54-342 Taleo Enterprise -
Reporting on Profile Sources/ Source TypesSummary OBI Assistance- Profile Source FieldsContent Hello, I am trying to splice out my "Profile Source" field in OBI into two separate columns. Current report: Candida… -
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…User_2025-01-25-05-14-55-725 46 views 2 comments 0 points Most recent by User_2025-01-25-05-14-55-725 Taleo Enterprise
-
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…User_2025-01-23-23-10-24-487 30 views 1 comment 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
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…User_2025-01-23-21-09-50-808 60 views 2 comments 1 point Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
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 …User_2025-01-23-22-02-51-715 45 views 1 comment 0 points Most recent by Rachel Martorelli-Oracle Taleo Enterprise
-
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…User_2025-01-23-22-10-45-747 50 views 0 comments 0 points Most recent by User_2025-01-23-22-10-45-747 Taleo Enterprise
-
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…User_2025-01-23-22-13-40-899 48 views 5 comments 0 points Most recent by User_2025-01-23-21-51-52-012 Taleo Enterprise
-
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…User_2025-01-23-21-55-28-650 83 views 3 comments 0 points Most recent by User_2025-01-25-01-54-55-414 Taleo Enterprise
-
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 User_2025-01-24-00-31-09-157 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 …User_2025-01-23-23-38-26-219 120 views 5 comments 1 point Most recent by User_2025-01-23-21-26-45-010 Taleo Enterprise
-
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…User_2025-01-23-22-10-45-747 42 views 1 comment 0 points Most recent by Stephane Cote-Oracle Taleo Enterprise
-
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…User_2025-01-23-22-24-54-342 59 views 4 comments 0 points Most recent by User_2025-01-23-22-24-54-342 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…User_2025-01-23-22-13-40-899 63 views 5 comments 0 points Most recent by User_2025-01-23-22-13-40-899 Taleo Enterprise
-
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…User_2025-01-23-22-02-51-715 77 views 15 comments 0 points Most recent by User_2025-01-23-22-14-30-510 Taleo Enterprise
-
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…