I've run into a problem calculating a price column in a report. This column is defined to be an average when aggregated. It changes based on date so pulling it for a day should result in the price on that date. The table this column exists in is joined to a fact table using a left outer join with a 0 to 1 relationship. When I include this column in a report is sets the calculation to:
, sum("T0"."C20") over ()/nullif(sum("T0"."C21") over (), 0) "Contract___Delivered_Price"
(entire query is attached)
This is causing every row in the report to be the same number instead of an average of each row. The report worked previously. I don't understand what is causing it to do an average over(). We've applied a couple patches to our Cognos 10.2.1 environment but I didn't see any bugs related to this problem.