Group By Function Error
Content
Hello,
I'm trying to used the ranked last function and group by Person Number to pull the employee's latest assignment, but I keep receiving the below error. I've used the Group By function before, but for some reason it's not working on this report.
State: HY000. Code: 42020. [nQSError: 42020] GROUP BY clause, [Dim - Employee.Person Number], is inconsistent with the projected columns in the SQL query request. (HY000)
Version
20D0