Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
morning
i have a qw document where
i have the next expression, that works ok
(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas"}>} FD_F_IMPORTE)))
now i need get that works to previous year
we have two fields (año(year) and mes(month) (2013 march) , when they are selected the variables:
fechas= 31/03/2013
fechas_prev_year= 31/03/2012
i just try to modify the expression but i didn´t get any.
(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas_prev_year"}>} FD_F_IMPORTE)))
(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas_prev_year"},Año= {$(#=Only(Año-1))}>} FD_F_IMPORTE)))
can you help me?
thanks and sorry for my english
regards
Try disabling the selections in Año and mes:
(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas_prev_year"}, Año=, Mes= >} FD_F_IMPORTE)))