Hi,

The current Member Key Column has the following SQL expression:

case when "dbo"."olap_portvalue_facts_daily3"."flows">0 then 0 else 1 end

What I want would be something like this:

case when sum("dbo"."olap_portvalue_facts_daily3"."flows")>0 then 0 else 1 end
group by date

Naturally simply entering it as above doesn't work.

The effect of the GROUP BY is to filter out days where you have flows and they
cancel one-another out (negative and positive of the same value).

Any ideas or suggestions appreciated.

pat

Any chance you can make this value a fact in your fact table instead
and then sum it up in your cube?