Error Code: 1111. Invalid use of group function

[Omar Qouqas]

I have been trying my best but I am now confused why this query does not work and returns an error (Error Code: 1111. Invalid use of group function). Query below:

update report_utilization ru
set avg_capacity_in = round(avg(((reports.infinera_utilisation.rx_octets*8)/900))) / reports.opsdb_circuit.circuit_absid
where year = 2017 and month = 5 and base_absid = 27957 and service_type = 'LMD';