aggregation with set analysis issue

[#1]

Hi All!

I hope i can get you to understand my issue,

got a table containing the following fields:

ID, StationID ,Date, Box, Active

i need to present a number counting how many StationsIDs are following these rules:

1. Box= Yes

2. Active= Yes

3. Date= (last max value, already got this from a different table, can call id Max_date..)

3. Date= in last year

I am having issues combining all of these together trying to use Aggr and set expressions..

=Aggr(count(DISTINCT

  {$<Date = {"Year to Date"}, Active={"Yes"}, Box={"Yes"}}>} 

  StationID),max_date,StationID)

Will appreciate any help!

[MK_QSL]

Provide sample app or dummy data.