Average rows that contain values.

Stimulsoft Reports.NET discussion
Post Reply
mmurdock
Posts: 94
Joined: Tue Mar 20, 2007 4:59 pm

Average rows that contain values.

Post by mmurdock »

Is there a way to average only rows that contain values in a dataset?

Thanks,

Mat
Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Average rows that contain values.

Post by Edward »

Hello, Mat.

Yes, there is the way. You have to declare an int type variable in the Dictionary, in the BeforePrintEvent increase it if its value is not null.

Please open the attached sample in the Demo example application from the standard installation.

Then divide resulted sum into value of that variable.

Thank you.
Attachments
84.AverageExceptNulls.mrt
(18.81 KiB) Downloaded 353 times
Post Reply