Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Im looking to calculate the average production per day using networkdays for the current month. The data is cumulative of the current month only pulled weekly. End of week 1 would like to show the average total transaction for that week and so on. Thank you.
Hi @danieldors ,
Taking only what you said, maybe this can be close to what you may need (see attachment). If you can share some data sample, will be easier to understand and help you.
=Avg( Aggr( sum([Production]) / NetWorkDays(Min([DateProd]),Max([DateProd])), [WeekProd]) )