15 Replies Latest reply: Nov 16, 2017 9:03 AM by Sunny Talwar RSS

    How to get max date

    naveen kumar

      Hello All,

      Capture.PNG

       

      In  a line chart I have two Dimensions:

                                                                        1)Fiscal Year

                                                                        2)PROD_HIER4_Name

       

      I need to write expression where it has to pick  MAX--VALIDFROM date's ---->Average PRICE_MAT at PROD_HIER4_Name level

       

      in the above case  it has to be       (2208.27+1722.9)/2 irrespective of BMATERIAL

      I Tired the below expression but I am not getting any output...

       

      aggr(avg({<VALIDFROM={'$(=max(PRICE_MAT))'}>}PRICE_MAT),PROD_HIER4_Name)


      what am I missing in above expression


      Thanks