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)))
Can you try:
Count(Distinct {<Scheduledate={"$(= '>=' & Today() & '<=' & Today())"}>}ID )
THanks
Try:
Count({<Scheduledate={'*'}>}Distinct ID)
Or:
Count({<Scheduledate={'?*'}>}Distinct ID)
Maybe
Count(Distinct {<Scheduledate={">01/01/1900"}>}ID )
can help you
Thanks. I missed here one thing. Actually I need to get the count of IDs whihc have Scheduledate morethan date
i,e today the date is 25/02/2014. I need to show the count of IDs where Scheduledate> 25/02/2014. like the very same way if I pull the report suppose on 28/02/2014 I need to show count of IDs where Scheduledate> 28/02/2014
Is it possible?
=COUNT{<Scheduledate -= {''}>}DISTINCT ID)
Clever Anjos's response should solve that.
Count(Distinct {<Scheduledate={">25/02/2014"}>}ID )
Hi,
I would solve this by using a flagfield and set analysis:
Script: If(Isnull(ScheduleDate,0,1) as FlagScheduleDate
Expression: Count({<FlagScheduleDate = {1} >} ID)
If you have a 1:1 relationship between schedule date and ID ánd the ID's are distinct, you can also use Sum(FlagScheduleDate) as an expression.
Cheers,
Michiel
Thanks. when I used this it is showing garbage after expression "{"
may be the expression is
If(Isnull(ScheduleDate),0,1) as there is a typo mistake in your expression in above reply