6 Replies Latest reply: Oct 22, 2016 6:46 AM by Shraddha Gajare

# MTD - LMTD

Hi everyone

I want to calculate MTD and LMTD.

MTD:

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.

LMTD:

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-01-2015.

• ###### Re: MTD - LMTD

For MTD:

Sum({<Date = {">=\$(=max(MonthStart)) <=\$(=max(Date)) "} >}  Sales)

For LMTS:

• ###### Re: MTD - LMTD

Try this:

MTD

Sum({<Date = {"\$(='>=' & Date(MonthStart(Max(Date)), 'DD-MM-YYYY') & '<=' & Date(Max(Date), 'DD-MM-YYYY'))"}>}Measure)

LMTD

Sum({<Date = {"\$(='>=' & Date(MonthStart(Max(Date), -1), 'DD-MM-YYYY') & '<=' & Date(AddMonths(Max(Date), -1), 'DD-MM-YYYY'))"}>}Measure)

• ###### Re: MTD - LMTD

Hi Sunny

This calculation is not work for my app. Result of this formule is zero.

• ###### Re: MTD - LMTD

Is your date format DD-MM-YYYY like its used in example above? or is it something else. Make sure to read this thread to understand Dates in Set Analysis

• ###### Re: MTD - LMTD

Hi

Try this :

MTD :

YTD

Sum({\$<[Date] = {'>=\$(=MonthStart(Today()))'}>} [Sales])

LMTD

• ###### Re: MTD - LMTD

also you can try:

For MTD:

Sum({<Date = {">=\$(=max(MonthStart)) <=\$(=max(Date)) "},Month=,Year= >}  Sales)

For LMTS: