1 Reply Latest reply: Apr 10, 2013 9:08 AM by Gysbert Wassenaar RSS

    help with sum expressión

    Jorge Trillo Rios



      i have a qw document where



      i have the next expression, that works ok




      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