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)) "


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


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