This content has been marked as final. Show 5 replies
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.