Conditional Count expression

[Anonymous]

Hi,

I am new to QV world just learning basics. I am looking for help with conditional count expression. Searched here, but did not find what I needed.

I have two data columns - Name and Certification date. I want to create text box showing count of Names that are not certified (= empty cell for Certification date). What is the right syntax for expression?

Also what the right expression would be if I want this shown as percentage from total of Names?

Thanks for help.

S.

[Anonymous]

Try

=count(if(not(isnull([Certification date])),Names))

[tresesco]

=Count(Distinct If(Len(Trim([Certification date]))=0, Name) /Count(Distinct Name) *100

[Yousef_Amarneh]

create a flag in your script and name it IsCertified and but the following if(IsNull(Certification date),0,1) then reload the script

in your report set the following expression count({$<IsCertified{0}>} Name)

[Anonymous]

Thanks, but this doesn't work. Shows Error: Nested aggregation not allowed.

[tresesco · Accepted solution]

Sorry a bracket was missing. Try:

=Count(Distinct If(Len(Trim([Certification date]))=0, Name) ) /Count(Distinct Name) *100

[Anonymous]

Thanks. This works. I have just removed "not" so it counts empty cells.

[Anonymous]

Now works. Thanks a lot !

[breno_morais]

Thanks. You help me a lot, I did not know the "not"

[hector_obregon_]

Thanks so much my friend...