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
39
Views
1
Comments
edited Dec 8, 2017 4:01PM in Reporting and Analytics Taleo Enterprise 1 comment

Summary

Formula Help Needed

Content

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.

Register

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