13 Replies Latest reply: Nov 23, 2017 6:03 PM by Sunny Talwar RSS

    Max date wise price and name

    naveen kumar

      Hello All,

                    I am trying to show Each persons latest price based up on calendar dates ,so to achieve requirement I had return the below expression

                              avg({<SCOPE={'YES'},SPrice_Calday={'$(=max(SPrice_Calday))'}>}Sprice_Price)


      but for some reason it is randomly picking only one max date which is 01-10-2017 and showing only those name and price ,and the rest of name it is considering under null, what I mean is


       

      It is showing only those name and price whose max date is 01-10-2017

      Capture.PNG

      Consider under null for below names whose max date is 31-03-2017

       

      Capture1.PNG

      I am trying to show in a straight table

                                                    Dimension: 1.Name

                                                                        2)Sprice_Calday

       

                                                       measure :

                                                                  1)  avg({<SCOPE={'YES'},SPrice_Calday={'$(=max(SPrice_Calday))'}>}Sprice_Price)


      What am I missing in my expression


      Thanks