get error when using sql to display total list by department

 
1
0
-1

this is my sql,

it appears here, but when preview, it shows error:

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Okay, try to remove the space between the COUNT and (c_processID).

      And please make sure that the processID is within the same form. ( app_fd_mrs)

      Might as well that is causing the issue.
      Let me know how it goes.




      1. dayana afiqah

        hi, how to filter it by month now? is it possible?

      CommentAdd your comment...