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