Non-zero weighted average

[alwayslrN]

I am using Crystal XI and was wondering is using running total the only and best way to create a weighted average the does not include zero values?

The weighted average function includes zero values in the weighting and the user does not want that to happen.

Thanks

 

[IanWaterman]

YOu will have to use two Running totals which only evaluate when the value is not equal to zero. One to sum and one to count. Then in summary use another formula which calculates avearge from these two RTs.

Ian