Financial Year LYTD expression

[shwetagupta]

Hi all,

I am using following expression for calculating LYTD but I am not getting the correct result as an output

Sum({<fYear=, fMonth=, Quarter=, Date={">=$(=Date(YearStart(Max(Date),-1)))<=$(=Date(addyears(Max(Date),-1))) "}>}invoice_qty)

my financial Year starts from April.

Problem : Date(YearStart(Max(Date),-1) what changes should I make in the expression in order to make it understand

Date(YearStart(Max(Date),-1)) = 1/04/2015  right now it is giving me 01/01/2015

Any help will be appreciated !!

[sunny_talwar · Accepted solution]

Try the third parameter here:

=Date(YearStart(Max(Date),-1, 4))

[shwetagupta]

Thanks a Ton Sunny for your help !!

[sunny_talwar]

No worries, glad I was able to help