Sort an aggregated set
Sort an aggregated set
Greetings,
I have need to aggregate the results of an expression, then sort by the aggregated column. I've tried to do this a number of different ways, but I get an error each time.
It appears that we are unable to sort a 'Summary View'.
And it appears that I am unable to place the 'group by' on the query table that I need. Here's my query.,..
SELECT upper("Site"),
sum(ROUND(("Per Month Income") * ((YEAR("Next Paid Date") - YEAR("Date Paid")) * 12 + (MONTH("Next Paid Date") - MONTH("Date Paid")))))
FROM "dp_sales_4-25-2008"
GROUP BY
upper("Site")
When I am in design mode, this query executes with no problem, and gives me the first 10 results. But if I hit save I get an error:
"
Sorry, an unexpected error occured when performing this operation. The error has been logged and will be looked into.
It would be of great help if you could provide us with additional information using the 'Feedback' link at the top of this page."
Any help you can provide would be greatly appreciatd.