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

    How to get max date

    naveen kumar

      Hello All,



      In  a line chart I have two Dimensions:

                                                                        1)Fiscal Year



      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...



      what am I missing in above expression