Using a Running Total should work.
In the Summary Section, choose the field with the zeros and the type of summary would be "average".
In the Evaluate Section, choose "Use a formula" and click on the formula icon. Enter the following formula: {your fieldname} <> 0
In the Reset Section, choose "On change of group" and select the group you're using for the average.
Click "Ok" and drop the Running Total into the Group Footer