Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Formula Help Needed — 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

Formula Help Needed

Accepted answer
edited Dec 8, 2017 4:01PM in Reporting and Analytics Taleo Enterprise 1 comment


Formula Help Needed


I have a situation where I need to write a formula and I am not sure how to most effectively/accurately accommodate this need. 

Scenario:  I have 4 dates, across a group of submissions.  I need to look at date 3, if that doesn't exist, use date 2, if that doesn't exist, use date 1.  Then need to find the difference between that result and date 4.  And now average that for the group of submissions.  I need to do this for multiple times and have one neat row of result columns.

Any ideas would be appreciated!

Howdy, Stranger!

Log In

To view full details, sign in.


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