7 Replies Latest reply: Jun 13, 2018 7:11 AM by Anthony Richardson RSS

    counting records between two values

    Anthony Richardson

      i need to count the records between two values, heres what i got and its erroring on me


      count(if((mid([PIID],10,1)<>'G') and ([Base And Alloptions Amnt]'>150000<=50000') and ([Mod Number] = 0) and ([Contr Office ID] <> left ([RefIDV PIID],6)),[Contr Office ID]))


      can someone please tell me what i'm doing wrong.


      thank you