2 Replies Latest reply: Sep 7, 2015 3:59 AM by Amith Murali RSS

    Show Data for the Last available date on a selected month.

    Amith Murali

      Hi guys,

       

      I have a Reports in which i have to show them the daily sales. by default it should show the latest dates data and it is showing but when i select some months the value is 0.

       

      The equation i used is " sum({<NumMonth = {"$(vMaxNumMonth)"},Date = {$(=max(Date))}>}(MonthSale)) "

      Where

                 vMaxNumMonth = =max({<Year = {"$(vMaxYear)"}>}NumMonth)

       

      It should show the Last available date on the selected Month.