Hi,
I´m trying to calculate an average using a script logic but I´m having problems with the u201CPRIORu201D command.
I want to calculate the average of the 3 priors periods of the period that the user will select to execute the Dts.
I have tried:
*xdim_memberset Category=Real
*xdim_memberset Time=PRIOR(3),PRIOR(2),PRIOR(1),%Tiempo_SET%
*xdim_memberset Account=PL00011
*When Time
*is <> %Time_SET%
*When GenericaFIT.Parenth1
*is Concesiones_Total
*rec(Factor=1,Category=%Categoria_SET%,Time=%Time_SET%,Origen="Logic",CeCo="NACeCo",Sociedad="NASociedad",Canal="NACanal",Marca="NAMarca",Pais="NAPais",Account="Reparto_VC")
*Endwhen
*Endwhen
*COMMIT
The problem is that the logic doesn´t aggregate, it only save the amount of PRIOR(1)
Thanks,
Daniel