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

Formula for Business Objects custom variable in OBI

Accepted answer
48
Views
2
Comments
edited Sep 11, 2021 9:57PM in Reporting and Analytics 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!