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
edited Dec 13, 2022 7:05AM in Taleo Enterprise 2 comments


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.


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.


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