2 Replies Latest reply: Apr 29, 2016 10:51 AM by Gysbert Wassenaar RSS

    data equal expression not working?

      I have a table

       

        

      datesddrp
      12-04-16100
      12-04-1650
      13-04-1625
      13-04-1630
      14-04-1645
      14-04-1635

      and i need to get the

      1.) max(date) sum of sales value. max(date) should be a variable

      2.) day before the max(date) sum of sales value