0 Replies Latest reply: Feb 13, 2013 7:27 AM by Göran Hofstedt RSS

    Help with a expression

    Göran Hofstedt


      I have this expression 



      (aggr(sum(Time_Per_Day)*count(distinct Date), Date,OrderTxt, OrderID,CustomID) / 60) 


      How do I add so it only do the calculation for max(OrderID) for each CustomerID and DeparmentNr?

      Today it sometimes gets wrong beacuse if a order are changed the first are not removed, instead a new are created and I only want to sum the time for the latest order


      Please let me now if I should give a better context.  


      Edit: maybe hard to read in above textbox

      sum(aggr(sum(Time_Per_Day)*count(distinct Date), Date,OrderTxt, OrderID,CustomID) / 60)