How to count without null (null value in datetime)

[missain89]

Hi can someone help me to figure out this

= If(Len(Trim(allconvoyear))=0, Null(),count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'}>}allmatric_no))

i dont want to count null value for allconvoyear because in my graph the convoyear null value is showing the null value 9k++

[Arthur_Fong]

Try this:

count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'},allmatric_no-={"=Len(Trim(allconvoyear))<1"}>}allmatric_no))

[missain89]

urm still not working 😞

[Arthur_Fong · Accepted solution]

Try this:

count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'},allstatus-={"=Len(Trim(allconvoyear))<1"}>}allmatric_no))

If still not working, please provide sample app.

[missain89]

still not working,

here is my sample app

[StarinieriG]

Hi 

try with this expression

count({<allstatus={'TAMAT PENGAJIAN','BELUM BERKONVOKESYEN'},eduPersonAffiliation={'Sarjana Muda','Doktor Falsafah','Diploma Lepasan Ijazah','Sarjana'}>}

If(Len(allconvoyear)>0,allmatric_no))

[Brett_Bleess]

Did Giulia's last comment get things working?  If so, please be sure to use the Accept as Solution button on their post to give them credit for the help and to let others know what worked.  If you did something else, please consider posting that and then marking it, and if you are still working on things, leave an update for us.

Regards,
Brett