Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is the difference between Mtd and Lmtd?
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
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