what is the difference between Mtd and Lmtd?

Anonymous — Tue, 03 Feb 2015 16:29:56 GMT

Re: what is the difference between Mtd and Lmtd?

Anonymous — Tue, 03 Feb 2015 17:04:20 GMT

Hi,

MTD- Month to Date

When a date is selected and it will look for the Starting date of the Month to the selected date.

Ex: date selected is 14-02-2015 then MTD is 01-02-2015 to 14-02-2015.

MTD set analysis syntax as below:

Sum ({<Year=, Month=, Quarter=, Week=, DateField=, SalesDate= {">=$(=Num(MonthStart(Max(SalesDate))))<=$(=Max(SalesDate))"}>} Sales)

LMTD- Last Month to Date

When a date is selected and it will look for the Starting date of the Last Month to the selected date.

Ex: date selected is 14-02-2015 then LMTD is 01-01-2015 to 14-02-2015.

LMTD set analysis syntax as below:

Sum ({<Year=, Month=, Quarter=, Week=, DateField=, SalesDate= {">=$(=Num(MonthStart(Max(SalesDate,-1))))<=$(=Max(SalesDate))"}>} Sales)

Regards

Neetha