DBCalc Average function help

rbuser

I want to get the average of a field, but I want to exclude 0's in the
calculation.

Is there an easy way of doing this, or do I have to use a sum and count
where filed not = 0?

Thanks for an help.

digitalmetaphors

You'll have to use a TppVariable and its OnCalc event handler to perform the
calculation to not use zeros. Here is an example that uses variables to
calculate group based percentages using variables to get you started.

http://www.digital-metaphors.com/tips/PercentageOfGroupTotal.zip


Cheers,

Jim Bennett
Digital Metaphors