Is there a way to average only rows that contain values in a dataset?
Thanks,
Mat
Average rows that contain values.
Average rows that contain values.
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.
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