Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try: sum(Customer)/interval(monthend(max(Date))-monthstart(min(Date))-1,'D')
Try: sum(Customer)/interval(monthend(max(Date))-monthstart(min(Date))-1,'D')
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?