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

Look Back
How to do an average days to approve formula? — 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

How to do an average days to approve formula?

edited Feb 19, 2018 9:38AM in General Transactional Reporting (OTBI) 1 comment


Hi all,


I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it was approved in so I can create a trend analysis, I am struggling to create the average formula. I need to use this formula for many other OTBI dashboards (date of submitting expenses to approval for example). Any ideas please?


My Excel dashboard that I use macros from OTBI for which I am trying to replicate is below, as are my subject areas.



Howdy, Stranger!

Log In

To view full details, sign in.


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