Hi, I have a fact table with two measure columns one is cnt and other is val with count & sum measures defined over both columns. Val has either median or average for that day. Now if I want to calculate mean & median for a month I would be required to do the following, sum(cnt * val) / sum(cnt). I run the following query select sum(cnt * val) / sum(cnt) from test_table where data_type=23 and event_date between '2016-04-01' AND '2016-04-30'; I get a NullPointerException. Complete error attached to the mail. I am guessing this is probably due it not being able to find a realization that matches the sum(cnt * val) measure. If not is there something else I am doing wrong ? Usually when you try to query with a aggregation that is not a part of the cube the error is that it can't find any realizations. But this query just returns null.
Are there any plans to support these kind of aggregates ? Thanks, -Joel
error
Description: Binary data
