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

Reporting Counts: # of Times a Req has been Posted/Unposted

Accepted answer
24
Views
2
Comments
edited Apr 7, 2017 5:37PM in Reporting and Analytics Taleo Enterprise 2 comments

Summary

Need to determine a formula to count the distinct times a req has been posted and unposted during the duration of the req life cycle.

Content

I have developed a formula to count the event: Transaction Even Type: Requisition unposted and to count the number of times it was moved to unposted. Based on the formula i return a count of 12, but when i look at the details of the Reqs i am only returning 3 Transaction Dates tied to the Transaction Event Requestion Unposted.

count (distinct case when ("Requisition Tracking History"."Transaction Event Type" = 'Requisition Unposted') then "Requisition Tracking History"."Req. History Transaction Date" end)  

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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