### Total Distance for last 7 days

Posted:

**Fri Aug 09, 2013 1:29 pm**I would like to have a rolling 7 day total of my mileage.

I thought Calculated Fields might allow me to get that

From Examples I selected Sum of last 7 days

The expression I got was {DISTANCE(SUM,7)}

I selected a day and calculated the field.

I got 68,206.3 in the field.

I can't run that far in a week.

I was expecting 42.76

Please Advise

I thought Calculated Fields might allow me to get that

From Examples I selected Sum of last 7 days

The expression I got was {DISTANCE(SUM,7)}

I selected a day and calculated the field.

I got 68,206.3 in the field.

I can't run that far in a week.

I was expecting 42.76

Please Advise