Thank you @Jennifer_Dungan ,I tried this and as you mentioned its strictly for last 7 days from the current date. The 4.06% is the kind of value I am looking for. Summary number makes perfect sense. However, the date range I have is couple of months old. "Last 7 Day Average" will only make sense if ...