5 Replies Latest reply: May 9, 2013 6:03 AM by Andrea Rebora RSS

    avg lead time with number order dimension in a chart

      Hi ,

      I would make a chart with dimension "N.OrdFor" (Order number supplier) and an expression that shows a "order extimated arrival date" for incoming orders.

       

      I have "OrderDate" in the script

      I have "OrderArrivalDate" ( is the date when the order has arrived, obviously if the order has not  arrived yet this field is empty)

       

       

      I don't have a "Supplier Lead time " field  in the script , but I can extrapolate it with this expression ?

       

      AVG(OrderArrivalDate-OrderDate) only for the orders that has already arrived, for the incoming orders it not works

       

      What should be the correct expression?

       

      (I made this one =DATE(OrderDate+Aggr(Avg(DataCaricoForn-DataOrdForn),RagSocForn),'DD/MM/YYYY')

       

      Many thanks

       

      Andrea