Business Objects Question - "Req. Avg Days From 1st Fully Approval Until Now (Minus D.O.H.)
I am trying to calculate the total days open for a requisition - excluding the total days on hold NOT minus the total days on hold.
For example, if a req was open for a total of 10 days, but on hold for a total of 3 days, I want the value returned to be 10 and not 7.
I was trying to use the "Req. Avg Days From 1st Fully Approval Until Now (Minus D.O.H.)" business object, but the calculation is completely off. How are others calculating this value?
Thank you in advance for your help.