Help with Date Set analysis

[hopkinsc]

Hi, i need some help with some set analysis.

I have a field 'Reporting Year Index' which is currently '6' for this year.

I am trying to get some set analysis working which will sum YTD sales.

Sum({<Trans_Date={$(=max([Reporting Year Index))}>}Sales)

Can anyone see what i am doing wrong please?

[hopkinsc]

Hi All,

I still can't get this to work..

[Anonymous]

I've fixed a few errors in your expression:

=sum(

{<Status_Date={">=$(=YearStart('1/1/2009',max([Reporting Year Index])))<=$(=YearEnd('1/1/2009',max([Reporting Year Index])))"}

,[Comment Date]={">=$(=YearStart('1/1/2009',max([Reporting Year Index])))<=$(=YearEnd('1/1/2009',max([Reporting Year Index])))"}>}

[Job Count])

The errors were:

1. As pointed earlier, 1/12009 is no a date.  Replaced with 1/1/2009

2. There is no field "Reported Date Index" in your app.  There is "Reported Year Index".

3. Added max to specify the index.

Now, if you don't select index, the max is 6, and the year is 2015.  The expression result is 0.  You have to select earlier index to get the non-0 result.  Or, use 2008 instead of 2009 in the expression, as in the attached example.