Count

[samuel_brierley]

Hi first of all thanks for any help,

What Im looking for i think is relativly simple,

all I want the expression to do is count everything that is less than the date selected.

count ( {$<[Fault Id]={"<[Date Detected]"}>} [Fault Id] )

so basically count the fault ID if the date detected is less than the date I select using a calender

[nizamsha]

count ( {$<[Fault Id]={"<$(=Date([Date Detected]))} [Fault Id] )

[michael_maeuser]

is the fault id a date field? if so, make sure it is also loaded with date(fault id) as fault id

[MayilVahanan]

Hi

Try like this

count ( {$<[Fault Id]={"=[Fault Id]<[Date Detected]"}>} [Fault Id] )

[v_iyyappan]

Hi

Use like this

=count({$<[Date Detected]={"<$(=Date([Date Detected]))} [Fault Id])

Regards,

[CELAMBARASAN]

Hi,

Try with this

count ( {<[Date Detected]={"<$(=Date(vDateSelected,'Your Date Format'))"}>} [Fault Id])

[er_mohit]

Try this

count ( {$<[Date Detected]={"<$(=Date([Date Detected]))"}>} [Fault Id] )