2 Replies Latest reply on Aug 17, 2016 6:03 AM by Cristian Ionescu

    Calculate average by period if the occurrence is not daily

    Cristian Ionescu

      Hi, all

       

      I have a small issue with calculating average demand for certain part numbers.

       

      In my dummy data example, in the daily demand sheet, you can see that for PN 123 I have demand only in 4 days out of 7 in the first fiscal week of April. (I have plotted in the third row the number of days the demand is divided by)

       

      My question is how can I make sure that the average demand over a week/month(depending on the selected level of the time hierarchy on the columns shelf) is calculated for all the PNs with 7 days(or 5) in a week, 22/23 in a month(depending on the month), etc.

       

      Message was edited by: Cristian Ionescu