Year selection is not working

[Anonymous]

Hi,

Below is my Expression and i have a list box FinancialYear.

SUM({<[Moved From]=,[Moved To]=,%TFromToKey =, %MFromToKey=,PostingDate=,dtmAddedOn={'$(=vMaxWeekStartDate)'},

  Opp_Status={'Closed'},CalendarMonthAndYear=,CalendarMonthName=,FinancialYear=,GoLiveFlag={1},[Probability %]=,Probability=,LastandCurrentMonth=

  ,[Billing Start Date]={">=$(=Date(YearStart(vMaxWeekStartDate,0,4)))<=$(=Date((vMaxWeekStartDate)))"}

   >}Amount_in_USD) .

On selction of FinancialYear im getting value for FY15 and not getting value for FY14.

vMaxWeekStartDate =Date((MAX({1<CurrentDateFlag={1}>}PostingDate)))

Kindly please kind suggest me if any expression corrections required.

InAdvacne

Thank you

[giakoum]

your problem is this one obviously :

[Billing Start Date]={">=$(=Date(YearStart(vMaxWeekStartDate,0,4)))<=$(=Date((vMaxWeekStartDate)))"}

vMaxWeekStartDate =Date((MAX({1<CurrentDateFlag={1}>}PostingDate))) means that you only get results for 2015. The 1 identifier makes sure that this is the case, regardless of selections.

try replacing 1 with $ but most likely the solution will be more complicated than that