Skip to Content
0
Former Member
May 06, 2010 at 02:26 PM

prior() in locgic whit problems

34 Views

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