Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
How can I convert the following expressions into a script?
= LINEST_M(Aggr(avg( If(DVPG > '18/03/2020', VDAF) ), STCK, DVPG ), DVPG )
=LINEST_R2(Aggr(avg(DISTINCT If(DVPG > '18/03/2020', VDAF)), STCK, DVPG),DVPG)
The fields can be obtained from the following tables:VDAF and STCK => Table EmpresasSTCK and DVPG => Table Cotações
DVPG has the same content as the Field PERI, that can also be found at Table Empresas
How can I do that?Thanks