topic Re: Financial Year LYTD expression in App Development

Financial Year LYTD expression

shwetagupta — Wed, 10 Aug 2016 07:38:30 GMT

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 — Wed, 10 Aug 2016 07:40:39 GMT

Try the third parameter here:

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

shwetagupta — Wed, 10 Aug 2016 08:36:55 GMT

Thanks a Ton Sunny for your help !!

sunny_talwar — Wed, 10 Aug 2016 08:38:01 GMT

No worries, glad I was able to help