1 Reply Latest reply: May 14, 2013 2:30 AM by vikas mahajan RSS

    expression aggregate for supplier

      Dear All,

       

      I need a very helpfull information from you.

      I have an expression that show me the lead time of the supplier, using as a dimension the IdSupplier.

      This expression is  =NUM(AVG(OrderArrivalDate-OrderDate),'#.##0')

      I modified this expression, as suggested in this community, to have the forecast of OrderArrivalDate using the avg in a chart with the ID Order as dimension

       

      alt(OrderArrivalDate, OrderDate + avg({<OrderDate>}total <[IdSupplier]> OrderArrivalDate-OrderDate)

       

      This expression works quite well, but only if i select a specific Supplier.

      I need that this expression shows the avg of each supllier, not the avg of all supllier with out any selection on the suppliers

      I attach the chart for your perusal

       

      The Forecast Date should be different for each order's supplier. In red I highlight that the difference of two dates is always the same

       

      I hope you can help me, because it is very important for my schedules.

       

      Many thanks

       

      Best regards

       

      Andrea