Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
Try the third parameter here:
=Date(YearStart(Max(Date),-1, 4))
Thanks a Ton Sunny for your help !!
No worries, glad I was able to help