Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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