tjtalusan

Average function with condition

Discussion created by tjtalusan on Jul 11, 2012
Latest reply on Jul 12, 2012 by BruceHerbach

Hi,

 

I have a summary table where I use an average function in some of my calculation fields. This is basically my reference for my report. My question is, how do I get the average of fields that only have data or greater than 0 (see example below)?

 

Ex.

SV1-80

SV2-90

SV3-85

SV4-empty / null

 

The Average for this should be 85 and not 63 because I will not include SV4 in the computation.

 

Thanks in advance for your help.

Outcomes