Have not been able to replicate a Weighted avg query in ver 1.1.1 using a subquery that raun successfully in TDA 1.1.0. After I select one field and choose Group By, I can not repeat on a 2nd field. I get this error: ORA-00979: not a GROUP BY expression.
I have tried using various fields as a 2nd field selection upon which to Group By and get the same error.
Is there a workaround? This is a critical query for our group. Thanks