Creating reports and dashboards | Stimulsoft community forum

Posted: **Sun Mar 25, 2012 9:20 pm**

Hi !!

Is it possible to have conditional average ? I just wanted to calculate average of non-zero values in a data band.
Right now I am doing it manually dividing the sum by no. of rows having non-zero values.

Thanks in advance !!

Posted: **Tue Mar 27, 2012 9:19 am**

Hello,

You can use the following expression:

Code: Select all

{AvgIf(DataBandName, DataSourceName.FieldName, DataSourceName.FieldName != 0)}

Thank you.

Creating reports and dashboards | Stimulsoft community forum

Conditional Average

Conditional Average

Conditional Average