Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Help with Formula: most recent offer — Cloud Customer Connect
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

Help with Formula: most recent offer

Accepted answer
32
Views
7
Comments
edited Feb 20, 2018 1:19PM in General Transactional Reporting (OTBI) 7 comments

Summary

I need help creating a formula to pull in the most recent offer

Content

I'm pulling together a list of YTD offers.  I am finding records where the candidate has accepted the offer then declined a few days later.  I would like to the report to only show the most current offer.  I can not use the "Current Step Name" as some of the candidates have moved to "Hire". 

In the example below, I only want to see the Candidate Declined record

Any help would be greatly appreciated.  Thanks in advance.

 

Current Status Req. Identifier Submission Identifier Historical Step Name
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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