Need to find the average on multiple fields by id

I need to find the average on multiple fields for each id.
Given the data:
{id, maths, physics, english }
{CS001, 92, 85 , 76}
{CS002, 99, 75 , 66}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
{CS001, 92, 85 , 76}
{CS002, 92, 85 , 76}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
{CS001, 92, 85 , 76}
{CS002, 92, 85 , 76}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}
.
.
.
..
.

I need the output as the average of three fields for each of the member id

{CS001, 92, 85 , 76}
{CS002, 92, 85 , 76}
{CS003, 92, 85 , 76}
{CS004, 92, 85 , 76}

Please suggest.

Thanks !

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.