MTD

[niharikab]

Hi Experts,

Can any one please help me to exclude month and Year fields from the below set expression of MTD.

sum({<Year=,month=,
[Order Date]= {">=$(=Date(MonthStart(max([Order Date])),'MM/DD/YYYY')) <=$(=Date(max([Order Date]),'MM/DD/YYYY'))"}>}Sales)

Here i applied Year= and month= but i am unable to exclude month and year.Still selections are applied when i select 2012,2013...years

Please help me on this.

Thanks in advance. 

[tresesco]

You need to include this exclusion in max() being used in the expression as well, like:

sum({<Year=,month=,[Order Date]= {">=$(=Date(MonthStart(max( {<Year=,month=>} [Order Date])),
'MM/DD/YYYY')) <=$(=Date(max({<Year=,month=>} [Order Date]),'MM/DD/YYYY'))"}>}Sales)

[tresesco · Accepted solution]

Try like:

sum({<Year=,month=,
[Order Date]= {">=$(=Date(MonthStart(max({<Year=,month=>} [Order Date])),'MM/DD/YYYY')) <=$(=Date(max( {<Year=,month=>} [Order Date]),'MM/DD/YYYY'))"}>}Sales)

[albert_guito]

HI,

If you select a month or a year your [Order Date] will refer to this period.

If you need the current MTD you have to change the Order Date by Today() in the set analysis

sum({<Year=,month=,
[Order Date]= {">=$(=Date(MonthStart(Today())),'MM/DD/YYYY')) <=$(=Date(Today(),'MM/DD/YYYY'))"}>}Sales)

Ag+