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

Days of Difference Between Requisition Created and Requisition Approval Requested

Accepted answer
32
Views
1
Comments
edited Dec 28, 2017 4:42PM in Reporting and Analytics Taleo Enterprise 1 comment

Summary

Formula Question

Content

I am trying to figure out a way to calculate the difference in Days between Requisition Created and Requisition Approval Requested BY Req. Identifier when the following statements are true

1. Transaction Event Type equals to Requisition Created, Requisition Approval Requested

2. The earliest date of Requisition Created and the latest day of Approval Requested

Challenge: I don't know how to create a formula that could calculate the difference correctly while meeting two criterion.

Temporary Solution: I use MAX to sort out the latest date of "Approval Requested" in one column and MIN to sort out the "Created" date in a different column and do the calculation in Excel. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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