5 Replies Latest reply: Feb 12, 2014 8:39 AM by Ville Syrjänen RSS

    Max date from sales data

    Ville Syrjänen

      Hi all,

       

      I would like to show last date with sales on report in a Text box. What would be the expression? I have tried several, but non of them work.

       

      This is approximately what I need: Maximum Date from Sales-table where sum of SalesQty is not 0. There are a lot of dates in future without sales and that's why I can't just take max(date) from table.

       

      Br,

      Ville