Calculating in footer, a calculated field in details

[matt330]

The detail of the report looks similar to this.

Site # # Missed Dose Percent completed dose Enrolled
8003 2 98 100
8004 6 94 100

etc
etc

"Percent completing dose is a calculated field.

In the report footeer I'm summing total # of missed doses so here it would be 8, but I can't get the report to give me an average percent. Right now every time I run the report I have to manually make the percent completing dose a running sum, then divide that # by the # of sites, to come up with the percent completing dose across all sites.

What am I missing?

 

[uncle-lai]

In my experience the Sum() is not valid on calculated fields. What I had done is creating a invisible textbox alongside with the calculated field, set the Data Control Source to "= [YourCalculated Field]" and the Running Sum to "Over All". Then put this textbox in your formular.

Hope this work for you too.

Peter

 

[matt330]

Good idea - worked perfectly. Thanks!