AVERAGE ISSUE

[#1]

Hello all,

how can I calculate the average product sold in one month ,  where the divisor is not only the dates where the product is sold, but the total number

of dates in that period.

see abstracted example

Thanks in advance!

[Gysbert_Wassenaar · Accepted solution]

Try: sum(Customer)/interval(monthend(max(Date))-monthstart(min(Date))-1,'D')

[#3]

Thanks this works!!

Do you have also a suggestion to calculate this in case days are split in morning, -7-16, evening,17-24,

night 1- 6?