I thought about that as well. I tried changing the order of the variables, and it fails to calculate. If I leave it as is, at least it calculates an Average value, but it does it for ALL of the data, and it does not select the date range.
Reversing the variables in the expression gives no results.
- Ugh, Now it makes sense. Sorry. I knew that my dates/data only went up through 4/15/2015, but I didn't make the connection when I was using the expression. You suggestion works, and now I understand why. The '-80' gets me into the date range.