Previous Year Sale in set analysis

[#1]

I want to find the previous year sale for a particular day

For eg: If i am selecting 24-04-2014

I want to see the sales for 24-04-2013

I dont want to use master calendar

I want to do this in set analysis

Currently I tried this Formula

=Sum({<DATE ={<MakeDate((Year(DATE)-1),Month(DATE),Day(DATE))>}>}NET_AMOUNT)

But there is an error in this formula.

I am not good in set analysis.

Can anyone tell me whats wrong in this or how to achieve this simple in set analysis.

[PrashantSangle]

Hi,

Try like this,

Sum({<DATE={"$(=Date(Addmonths(DATE,-12)))"}>}NET_AMOUNT)

Or

Sum({<DATE={"$(=Date(AddYears(DATE,-1)))"}>}NET_AMOUNT)

Regards

[MK_QSL · Accepted solution]

=SUM({<TransactionDate = {'$(=MakeDate(Year(Today())-1,Month(Today()),Day(Today())))'}>}Amount)

Replace Today() with Date

[#4]

Its working fine.

Thank you so much.

Can u share me the expression for MTD & YTD Calculation also

[MK_QSL]

YTD

=SUM({<Date= {'>=$(=YearStart(Today()))<=$(=Today())'}>}Amount)

MTD

=SUM({<Date= {'>=$(=MonthStart(Today()))<=$(=Today())'}>}Amount)

Change Date and Amount with your respective Fields....

Change Today() with your Date in case if you want to give Date selection to users...