Hi
I wish call variable into expresión aggr sum
Variable:
vSecosMex_MesNumerico =if(Date#(C_Mes,'YYYYMM')='201709', 201708
, if(Date#(C_Mes,'YYYYMM')='201710', 201719
, if(Date#(C_Mes,'YYYYMM')='201711', 201710)
)
)
Expresión:
aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={$(vSecosMex_MesNumerico)} >} Habil ) , N_Articulo )
This expression only work when use number value, for example:
aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={201709} >} Habil ) , N_Articulo )
aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={201710} >} Habil ) , N_Articulo )
aggr( NODISTINCT sum( {1<N_Mes=,N_Anio=,N_Mes2=,C_Mes=,C_Mes={201711} >} Habil ) , N_Articulo )
The next image was visualized the code:
I wish find value of other time and put certain date
Hope that helps,
Stalin