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)))

[Nicole-Smith]

Try:

Count({<Scheduledate={'*'}>}Distinct ID)

Or:

Count({<Scheduledate={'?*'}>}Distinct ID)

[Clever_Anjos]

Maybe

Count(Distinct {<Scheduledate={">01/01/1900"}>}ID )

can help you

[#4]

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?

[MK_QSL]

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

[Nicole-Smith]

Clever Anjos's response should solve that.

[Clever_Anjos]

Count(Distinct {<Scheduledate={">25/02/2014"}>}ID )

[mvanlutterveld]

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

[#9]

Thanks. when I used this it is showing garbage after expression "{"

[#10]

may be the expression is

If(Isnull(ScheduleDate),0,1) as there is a typo mistake in your expression in above reply