Previous year MTD

[#1]

Hi all,

I am using the following expression for calculating previous year MTD and previous year YTD

Previous MTD : num(Sum({<VISIT_DATE={'>=$(=MonthStart(MakeDate(Year(VISIT_DATE)-1,Month(VISIT_DATE),Day(VISIT_DATE))))

  <=$(=MakeDate(Year(VISIT_DATE)-1,Month(VISIT_DATE),Day(VISIT_DATE)))'}>}NET_AMOUNT)/vFactor,'##.##')

Previous YTD:

=num(Sum({<VISIT_DATE={'>=$(=yearstart(MakeDate(Year(VISIT_DATE)-1,Month(VISIT_DATE),Day(VISIT_DATE))))

  <=$(=MakeDate(Year(VISIT_DATE)-1,Month(VISIT_DATE),Day(VISIT_DATE)))'}>}NET_AMOUNT)/vFactor,'##.##')

Previous YTD expression is working fine.

But  for previous MTD expression I am getting Previous YTD value.

Can anyone tell me where I went wrong or Is there any other better way to calculate previous year MTD.

(note: I dont want to use master calendar)

[#2]

Hi Manish,

Thank you so much

Its working fine..