You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Formula for Business Objects custom variable in OBI

edited Dec 13, 2022 7:01AM in Taleo Enterprise 2 comments

Content

I am currently recreating several reports in OBI with custom variables from Business Objects such as the one below and I am having trouble creating the formula in OBI. We have multiple custom variables that indicate the date of when a candidate was moved to a specific status and then we do a days between between calculation between those custom variables. In the report there is typically one date from at least one status in each step of our CSW. 

=Max(([Application Historical CSW Start Date]) In ([Application ID]) Where([Application Historical CSW Status]="Intake OffAcc"))

Any ideas/help would be greatly appreciated. Thanks!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!