Excluding 0's while averaging in Crystal Reports [Archive]

rrmcaho

04-03-03, 10:56

I am trying to perform a group average in Crystal Reports 9. I need to exclude the 0's for the average. Can any help me on this?

K6Scorpion

04-11-03, 21:00

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