There isn't any rhyme or reason to your request, or at least none we can do as a generic solution based on that little data. Why is 0 to be ignored? That's easy to do:
SELECT ... WHERE ValueIDontWant != 0.0
But the rest? Why would one value be doubled, and the other halved? How many values does it apply to? All of them? Max and min? First and last? We don't know - and we can't work it out from your query because we have no idea what your tables or their data looks like.
And the query itself looks like you guessed, as I do not believe you really want to group by each of those columns. You do realise that each column you add to a GROUP BY increases the number of rows return, not reduces it, don't you?
Stop, sit down, look at your data tables and exactly what you are trying to return, and think about how everything relates before you start writing queries!