6 Replies Latest reply: Jul 9, 2012 1:57 PM by Patrick De Waegenaere RSS

    error in expression Sum-if

      Can somebody explain me why this formula does'nt work and show the error mesage:

       

      sum(if(Finalizada_Act =1 and sum(CantidadCont)-Sum(Aggr(Cantidad_Act, ActividadId_TTD))<>0,1,0))

       

      And what will be the correct one. Thanks in advance.

       

      Pat.