Nils %

[bazzaonline]

Hello,

I have a field of data containing various results ranging from 0 - 10000, I was to write an expression that calculates the % of nils per month.

EG, count all the 0's in the month and divide by the total number of results.

So 0, 0, 0, 1, 1, 2, 2, 3, 4, 5 would equal 30%.

Thank you

[Gysbert_Wassenaar]

count( {<SomeField={0}>} SomeField) / count(SomeField)

[bazzaonline]

Doesn't seem to work??

[#4]

count( if(SomeField=0), SomeField) / count(SomeField)

[#5]

HI

TRY THIS

=COUNT({  <F1={'0'}> }F1)/COUNT(F1)

[cspencer3]

or

sum(if(Field=0,1,0)) / count(Field)