Correct Expression help please?

[#1]

HI,

I need to calculate the count of ID which have Scheduledate where Scheduledate not equal to NULL.

can anyone help me with expression

I used below expression but it seems not getting data correct values

If(Scheduledate,Count(Distinct(ID)))

[mvanlutterveld]

Yep, you're correct.

[#3 · Accepted solution]

Can you try:

Count(Distinct {<Scheduledate={"$(= '>=' & Today() & '<=' & Today())"}>}ID )

THanks

[SunilChauhan]

hello ,

why not simply use below

Count(Distinct if( Isnull(Scheduledate)=0,  ID))

isnull give -1 for true and 0 for false

hope this helps

[MK_QSL]

=COUNT(DISTINCT {<Scheduledate -= {''}>} ID)

[#6]

Thanks.