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

    help with sum expressión

    Jorge Trillo Rios

      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