I want to create a calculated field to take average of both the columns, i.e. (3978+4013)/2
Currently my calculation is giving me 3978/2 and 4013/2 respectively.
Difficult to help without some sample workbook?
Deepak Rai attaching the workbook.
In your case, average is aggregation of aggregation and you need to use table calculations.
Retrieving data ...