1 of 1 people found this helpful
The date field needs to have an aggregation on it as well (because average_revenue is using an aggregation--they have to "match"). To fix this, change the calculation to be similar to the following:
Case year(max(date_month)) when 2010 then average_revenue else 0 end
The following KB provides more information on this error:
Hope this helps!
Thanks Tracy, I'll try that out and see if it gives the expected results.