Time range set analysis

[Ahmed_Hisham]

Dears,

Kindly can any one help with this script to calculate 12 month sum

Sum({<[Month Date.autoCalendar.Year]=, [Month Date.autoCalendar.Month]=, [Month Date.autoCalendar.Date]={">=$(=date(MonthStart(Max([Month Date.autoCalendar.Date])),M/D/YYYY), -11))<=$(=Date(Max([Month Date.autoCalendar.Date]),M/D/YYYY))"}>} Qty )

The date in load editor is

SET DateFormat='M/D/YYYY';

[PrashantSangle]

what is error you are getting?

[Ahmed_Hisham]

Hi,

it returns only the value of (=Date(Max([Month Date.autoCalendar.Date]),M/D/YYYY) not the sum of the range

[PrashantSangle · Accepted solution]

• Sum({<[Month Date.autoCalendar.Year]=, [Month Date.autoCalendar.Month]=, [Month Date.autoCalendar.Date]={">=$(=date(MonthStart(Max([Month Date.autoCalendar.Date]),-11),'M/D/YYYY'))<=$(=Date(Max([Month Date.autoCalendar.Date]),'M/D/YYYY'))"}>} Qty )

check above.. check all internal sets some of them incorrectly parameterised .

[Ahmed_Hisham]

Thanks alot,

It worked like a charm