Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
Yep, you're correct.
Can you try:
Count(Distinct {<Scheduledate={"$(= '>=' & Today() & '<=' & Today())"}>}ID )
THanks
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
=COUNT(DISTINCT {<Scheduledate -= {''}>} ID)
Thanks.