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