executeSQL select percent of group by
Hi, Sorry if this answer is posted in the forums, but I could not find anything. I am trying to use executeSQL return a list of distinct name, count, and percent. I am using the FMServer_Sample file that comes with FM Server. I changed the name of the column to EmployeeName so it is easier to deal with but basically there is a table in that file called: Tasks
This SQL errors with the ?. When I run the SQL in NetBeans as a JDBC client to the file the error is: FQL0005/(4:9): Expressions involving aggregations are not supported.
Interestingly, when I replace the second Count(*) call with a hardcoded number such as 200: