DistinctCount not including zeros

[jenschmidt]

Good Afternoon! I would like to subtotal a field with a DistinctCount, but I also want the subtotal to ignore the value of null or zero. Currently, when subtotaled, I expected to see a result of 59 and I'm seeing 60 instead. I've tried a few formulas to say only count if <> 0, but nothing has worked so far.

Any ideas?
Thanks!

jennifer.giemza@uwmf.wisc.edu

 

[GMcNamara]

Insert - Running Total. Change the type of summary to Distinct Count. Under Evaluate, select 'Use A Formula' and click the x-2 button. In the formula editor, enter the following:
not(isNull({table.field})) and {table.field} <> 0;

 

[synapsevampire]

Try using a Running Total, and in the Evaluate Use a Formula, insert {table.field} <> 0

Should work.

-k

 

[kutoose]

Giemza,

Did you try 'Running total' ? Use a formula for'Evaluate'

not isnull({table.field}) or {table.field} <> 0

kutoose@yahoo.com

 

[jenschmidt]

PERFECT!! Thank you!

jennifer.giemza@uwmf.wisc.edu