Set analysis in Script

[cristianj23a]

Hi.

Can someone help me enter this code to the Script please

=Aggr(

Num(Count(distinct{<DíaSemana={'*'}-{'dom'},%FILTRO_ACTIVOS={'ACTIVO'},[T554T.Clase absent./pres._AWART]-={'1003','1013','1015','1020','1022','1025'},PA0000.Fecha = {"$(='<=' & date(NOW(),'DD/MM/YYYY'))"}>}PA2001.Día),'###,###'),[PA0000.Número de personal_PERNR],[T554T.Clase absent./pres._AWART],Año,Mes)

[sunny_talwar · Accepted solution]

May be like this

LOAD [PA0000.Número de personal_PERNR],

     [T554T.Clase absent./pres._AWART],

     Año,

     Mes,

     Count(DISTINCT [PA2001.Día]) as Count

Resident .....

Where Len(Trim(DíaSemana)) > 0 and DíaSemana <> 'dom', %FILTRO_ACTIVOS = 'ACTIVOS' and not Match([T554T.Clase absent./pres._AWART], '1003','1013','1015','1020','1022','1025') and [PA0000.Fecha] <= Today()

Group By [PA0000.Número de personal_PERNR], [T554T.Clase absent./pres._AWART], Año, Mes;

[cristianj23a]

Thank You Sunny.