Condition in AVG
Hi guys,
I have groupfooter in my report. There is memotext [AVG(<DSSumar."Doba">)] in this groupfooter. But some values are 0. Is it possible to insert condition anywhere so that 0 values are ignored in average calculation?
Thanks for any idea,
USDarmy
I have groupfooter in my report. There is memotext [AVG(<DSSumar."Doba">)] in this groupfooter. But some values are 0. Is it possible to insert condition anywhere so that 0 values are ignored in average calculation?
Thanks for any idea,
USDarmy
Comments
use your own variable to track recordcount
in the obp of the data band write code to inc counter if value of field is >0
in the footer use sum function and / by counter variable.
thanks, USDarmy