Reporting Counts: # of Times a Req has been Posted/Unposted
SummaryNeed 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)