Conditional Average

Naveen Aggarwal · Post by **Naveen Aggarwal** » 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 !!

Post by **Alex K.** » 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.