Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sorry a bracket was missing. Try:
=Count(Distinct If(Len(Trim([Certification date]))=0, Name) ) /Count(Distinct Name) *100
Try
=count(if(not(isnull([Certification date])),Names))
=Count(Distinct If(Len(Trim([Certification date]))=0, Name) /Count(Distinct Name) *100
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)
Thanks, but this doesn't work. Shows Error: Nested aggregation not allowed.
Sorry a bracket was missing. Try:
=Count(Distinct If(Len(Trim([Certification date]))=0, Name) ) /Count(Distinct Name) *100
Thanks. This works. I have just removed "not" so it counts empty cells.
Now works. Thanks a lot !
Thanks. You help me a lot, I did not know the "not"
Thanks so much my friend...