Count records <> 0

[jorditorras]

Dear Gurus,

I'm trying to calculate a Total of different values excluding Null. In the example below, as there are 3 different Quotations Codes, I'd like to calculate a Total of Quotations = 3.

Company	Quotation Code	Quotations Counter
A01	RMX0242	1
A01	RMX0242	1
A01	RMX0242	1
A01	RMT9942	1
A01	RMT9942	1
A01	XXX4544	1
A01		0
A01		0

Total Quotations Counter = 3

Any idea of how I can get this? If I use the formula Count(Distinct([Quotation Number])) the result is 4 as it is counting also "null" value.

Thanks in advance!

Regards,

Jordi

[YoussefBelloum · Accepted solution]

Hi,

try this:

Count(Distinct {<[Quotation Number]={"=len(trim([Quotation Number]))<>0"}>}[Quotation Number])

[Anonymous]

try this

Count(Distinct {<[Quotation Counter]={">0"}>} [Quotation Number])

[jorditorras]

This is working. Thanks Youssef!!

[YoussefBelloum]

you're welcome

don't forget to close the thread

[jorditorras]

This solution is also countg nuls. But thanks anyway!!