Skip to Content
0
Former Member
Sep 22, 2014 at 04:42 PM

Distance Per Week

18 Views

Hello All,

I have to calculate Avg EV Trip Distance for each VIN in the week. This is done by summing all the EVTripDist and dividing by the total of unique VINs for that week.

Here are the fields which are needed

VIN_C

EVTRIPDIST_Q

CHRG_MONDAY

I am attaching sample date for your reference. We have so many records for VIN, EVTRIPDIST for a particular date ( For Ex: 1/21/2013).

I need to Sum "EVTRIPDIST" and calculate Distinct "VIN_C" for a particular date ( For Ex: 1/21/2013).

Best Regards

Sandeep

Attachments

Data.txt.zip (1.3 kB)