Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I have created 2 variables as below:
vStart =date(MonthStart( AddMonths(Max(TDATE),-6)))
vEnd =date(MonthEnd( AddMonths(Max(TDATE),-1)))
I am trying to use these variables to calculate last 6 months data in below expression. However it does not calculate.
It gives the result of the month selected.
=sum( {<TDATE={">=$(=vStart )< $(=vEnd)"}>}Sales)
Do I need to change any format of date or do any modifications in above expression or variable definition?
Thanks & Regards
Chintan
Hello Sunny
PFA Sample for few thousand records debug.
Thanks
Chintan
I think TURNOVER value is missing before Apr-2015, but if I select Apr-2015 it gives something like this
=Sum({<MonthYear={"$(='>=' & Date(MonthStart(Max({<TURNOVER = {'*'}>}MonthYear), -6), 'MMM-YYYY') & '<' & Date(Max({<TURNOVER = {'*'}>}MonthYear), 'MMM-YYYY'))"}, Month, Year, Monyr, TDATE, DATE>}TURNOVER)
It works!!
Thanks & Regards
Chintan