7 Replies Latest reply: Aug 30, 2016 7:01 AM by shweta gupta

# Previous to Previous year till date

Hi All,

I am trying to calculate current year over previous year over previous to previous year.

Where Date1 is my date field, vYear, vMonth, Vquarter are from fiscal calendar.,

For current year : sum({< vYear = {"\$(=max(vYear))"}>} invoice_qty)

For Last  year till date :

Sum({<vYear=, vMonth=, VQuarter=,

For last to last year till date(LLYTD):

Sum({<vYear=, vMonth=, VQuarter=,

In above expression I am not not getting values corresponding to LLYTD either it gives me the whole sum of three years or shows Zero.

• ###### Re: Previous to Previous year till date

Not possible !!!
Can you please suggest if there is anything wrong with the syntax used  for LLYTD

• ###### Re: Previous to Previous year till date

Say I am having 2012,2013,2014 then my question how you are defining till date today?

Like 01/Jan/2014 till Today : For Max Year

01/Jan/2013 till Today or Till  01/Dec/2013 ??

• ###### Re: Previous to Previous year till date

till today means :

Say for current years sales from 01/04/2016- 30/08/2016 (Data last loaded)

For Lytd  :  01/04/2015- 30/08/2015

For LLytd : 01/04/2014- 30/08/2014

• ###### Re: Previous to Previous year till date

Okay, then for Till today you can try Addmonths() like?

or

• ###### Re: Previous to Previous year till date

for both the mentioned cases, you can try these?

=Sum({<vYear=, vMonth=, VQuarter=,

Date1={'>=\$(=YearStart(Year(max(Date1))-2))<=\$(=YearEnd(Year(max(Date1))-2))'} >} invoice_qty)

or

=Sum({<vYear=, vMonth=, VQuarter=,

Date1={'>=\$(=YearStart(Year(max(Date1))-2))<=\$(=Date(max(Date1)))'} >} invoice_qty)

Make sure Date format should be same

• ###### Re: Previous to Previous year till date

None of them helped !!
Thanks a lot for the suggestions anyways