Description |
The calculations for days outstanding should :
sum(Closed date - create date) /number of calls closed in that period.
{color:#ff0000} *We should rename as days to close* {color}
see below
|Call|create date|time|closed date| |Days|
|1|1/1/2015|9:00am|1/10/2015|9:00 am|9|
|2|1/1/2015|10:00 am|1/5/2015|10:00 am|4|
|3|1/3/2015|10:00 am|1/3/2015|11:00 am|.41|
|4|1/3/2015|10:00 am|1/3/2015|9:00 am|0|
Days outstanding would be : 9.41/4 =2.35
|