I have created a report to calculate how many days on average work orders are open by crew.

I have grouped the report by work crew and in the details section included the requisite information, as well as a formula field to count the number of days each work order was/is open (including those still open).

@WODaysOpen=
if isnull({WKORDER.WO_END_DT}) then
(DateDiff ("d",{WKORDER.WO_STRT_DT} ,CurrentDate ))
else (DateDiff ("d",{WKORDER.WO_STRT_DT} ,{WKORDER.WO_END_DT} ))


In order to get the average, I created a running total field based on this formula field
Running Total Name: AvDaysOpen
Field to smarize: @WODaysOpen
Type: Average
Eval: for each record
Reset: on group

I then placed the running total field in the group footer and Presto! it seems to have given me the average number of days a work order remains open per work crew.

To get an overall average for all crews, I created another formula field
@AverageOpen =
Average ({@WODaysOpen})

My concern is that I can't tell if my logic is correct and there are thousands of work orders, so I'm disinclined to manually verify the output.

I hate to ask everyone, but I really want to make sure I'm tackling this correctly before proceeding. Does this method seem sound to you? I'm still learning CR, and reading threads in this forum has provided so much help.

I believe an average for all rows is what the report requester would like to see.

Good to know there is a simpler way as well. Thank you for the input!