13 Replies Latest reply: Nov 26, 2016 2:49 PM by Vineeth Pujari RSS


    Gourav Sikka

      Dear Team,



      I stuck a issue. My Requirement is

      Suppose we have a Sale Data from Apr to Jul

      And I want to Result



      When a person select May's any date then Sale would be Sum of From (01/04/2016 to 30/04/2016) Sale Showed in Report.

      But When i select Apr's Month Any Date then it Showing All Sale.



      But it should be sum of (01/04/2016 to 31/03/2016)   Sale Zero.

      but it is showing All Sale Value. Kindly Help me only for Solevingthis Requirement.







      For this i have make two Variable

      1. V_End_Month= Date(MonthStart(RangeMin(Date(Floor(Max(Link_Date)),'DD/MM/YYYY'),Date(Today()-1,'DD/MM/YYYY')),0)-1,'DD/MM/YYYY')

      2.v_YearStart= DATE(MonthStart(YEARSTART(vCurrentDate,0,4)),'DD/MM/YYYY')



      For Making vCurrent Date I use this Formula






      And I am using Expression in frontend



      =Sum({$<Link_Date={"<=$(V_End_Month)>=$(vYearStart)"},[Fiscal Year],[FY Year Name],[Fiscal Quarter],[Fiscal Month]>} Net_Value)





      For this i am sharing excel.And Qvw Maker