3 Replies Latest reply: Nov 10, 2017 2:21 AM by Shraddha Gajare RSS

    How to get price

    naveen kumar

      Hello All,

       

                  I need to pickup 31 st march average  price of each year ,what I mean is

      for Fiscal year 2018 =31-03-2017 date price

          Fiscal year 2019= 31-03-2018 date price

          Fiscal year 2020= 31-03-2019 date price....

      So on

       

      Capture.PNG

      Date Model:

      Capture1.PNG

       

      My first question is linking by fiscal year will work or not ,if it ok when how write a expression to bring

       

      If selected Fiscal Year =2018 then

       

      LOGIC:

      Previous fiscal year's(FY2017) --->max (SPrice_Calday's )(31-03-2017)----> Avg(Sprice_Price )

       

      Kindly give suggestions on above requirement please

       

       

      Thanks