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?

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

Content

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.

 

Thanks

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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