Could you post a packaged workbook so we can take a look and try to help you? If you've already found a solution, please share!
See bellow an example file.
I want to calculate the TotalDistance AVG of X and Y Days (X and Y may be a parameters) since a selected day. For example:
Selected Day: 20/06/2015
X= 7 days
Acute AVG (7 days): AVG considering only days 14th, 15th, 16th, 17th, 1.8th, 19th and June 20th
Let me know if you have any doubt.
Did you have any time to take a look at my case? Thanks
Você conseguiu resolver este caso?
Você tentou o fixed?.. eu fiz pelo fixed, porem o processo fica um pouco lento devida a quantidade de informações....
Aguardo seu retorno