General OBIEE

Get Involved. Join the Conversation.


    Doron de Jong
    How to do an average days to approve formula?
    Topic posted February 19, 2018 by Doron de JongRed Ribbon: 250+ Points, tagged Analyses, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, SQL 
    How to do an average days to approve formula?

    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.



    Doc2.docx (644KB)