Average For Specific Days

[former_member550083]

Hi All,

I have one requirement where customer wants day wise data and he wants to keep base line of first 7 days total for rest othere days and this base data will be use for all 30 days for per day count.

Please guide us what will be the formula we can use.

average.jpg

[Former Member]

Would this Work:

=Average ( ([Count]) Where( DayNumberOfMonth([Date]) < 8 ) ) in ( Year( [Date] ) ; MonthNumberOfyear( [Date] ) )

/Henrik