2 Replies Latest reply on Oct 10, 2018 6:21 PM by Alex Martino

# How to calculate daily average

How can I calculate the DAILY average? In the "real" data set, there might be days that don't show up. I want the average to still use those days (I have only a few days in this current example but in my real set there will always be 30 days)

Also, I will have category #1 and category #2, so I will want to calculate this daily average

When I calculate average now it just says "1" which isn't correct.

• ###### 1. Re: How to calculate daily average

Thanks

Deepak

If It Helps, Pl Mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 2. Re: How to calculate daily average

Hi Deepak. Thanks.

What are you doing exactly? I don't understand the second part of the formula.

And why doesn't the average formula work? Also, how do I then take the average of that 4 day period? I want the daily average of sales over the 4 day period, not just the days that show up. So it would be (.5+.5+.333)/4 days. Thanks!