3 Replies Latest reply: Aug 10, 2016 4:38 AM by Sunny Talwar RSS

    Financial Year LYTD expression

    shweta gupta

      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 !!