Calculated field to update directly on google sheets

[diegonet]

Hi Everyone,

I have two tables: "Results" & "Average". Each one in a sheet.

Table "Results" have this structure:

Table "Average" have this structure:

I want to update the sheet with the average calculated with AppSheet. I used this formula:

AVERAGE(SELECT(Results[Exam], [Student]= [_THIS].[Student]))

But I can't update on the sheet. How can I do it?

Thanks in advanced.

Regards,