Cannot summarize a running total field
Posted on 2004-11-17
I have 2 running total fields. #RT_Students and #RT_Room
I use a formula to do a calculation on the fields @Total = (#RT_Students/#RT_Room)
Now I need to get an average of this formula.
When I try to do this with another running total, the formula does not appear in the list. When I try to make a formula using the Average() function on the @Total formula I get this error 'This field cannot be summarized'
Is there any way around to achieve what I am trying to do?