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

    Logic

    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

      vCurrentDate=DATE(RANGEMIN(DATE(FLOOR(MAX(Link_Date)),'DD/MM/YYYY'),DATE(TODAY()-1,'DD/MM/YYYY')),'DD/MM/YYYY')

       

       

       

       

      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