You have chosen to sponsor your bid up to a maximum amount of .
I need some help finding root cause of an issue that I am working. For some reason one query in Production is doubling measure values when i use SUM and GROUP by functions. That is if i have 10 $ as sales when i use sum and group by it is appearing as 20$. I am using approx about 8 tables with some joins. Same query is working perfect in DEV environment.
Length of the query is probably around 55 to 60 lines