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



      Date Model:



      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



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


      Kindly give suggestions on above requirement please