Código SQL [-] ... select avg(costonuevo) from historicocostos where codigoproducto = new.codigo into New.CostoPromedio; ...
... select avg(costonuevo) from historicocostos where codigoproducto = new.codigo into New.CostoPromedio; ...