9 Replies Latest reply: Dec 5, 2012 11:18 AM by Jaime Marines RSS

    COUNT: Error in Expression

    Jaime Marines
      
      

      Hi!

       

      I need to count Fieldn..only if field1 =-2 and field2 <> -1 and field3 <> -1 and field4 <> -1 ...then I get Error in expression..Tk in advanced.

       

      COUNT (IF(Field1='-2' ,Field2<>'-1' ,Field3<>'-1' ,Field4<>'-1'),Fieldn)

       

       

      JMC