YTD calculation using GetFieldSelection

[#1]

I have some reports that populate the data within them by using the Get Field Selection function.  For example the user must select a month and year, and then the report will populate that dates selected units:

Sum({< detailmonth = {"$(=GetFieldSelections(detailmonth))"}, detailyear = {"$(=GetFieldSelections(detailyear))"} >} units)

This works great for getting month selected units, prior month, month over month comparision, prior year, and year over year comparison.  Now I need to get the YTD based on the month selected.  Meaning if they selected month 5  and year 2012 that it would sum months 1-5 for 2012, or if month 8 then sum months 1-8.  Anybody have suggestions on how to do this? I'm drawing a blank based on current design.

Thanks,

Rebecca

[MayilVahanan · Accepted solution]

HI

Try like this

Sum({<MonthField=,YearField=,DateField={">=$(=YearStart(Max(DateField)))<=$(=MonthEnd(Max(DateField)))"}>} FieldName)"

Hope it helps

[#3]

Perfect!  Thank you Mayil!  I was putting the <= in the wrong place.  I appreciate your help!!  Thanks again!