Calculating the average in a calculated field

[WonderMan]

Hi Everyone I'm new to Qlik sense and I want to add some columns to my source data. One of these columns needs to be the average of a particular column based on different other columns. Here an example of what I want:

Column F is the average of column E based on Column C and D

Thanks

[stevejoyce]

Load script:

left join (sourcedata)

[Code 1]

,[Code 2]

avg(Percentage) as [Added Column]

resident sourcedata

group by 

[Code 1]

,[Code 2]

;

front-end calc:

if [Code 1] and [Code 2] are your table dimensions:

avg([Percentage])