Aggregate is not allowed within USING clause of a FILTER operator.
568202Dec 7 2009 — edited Dec 17 2009hi all,
In the business layer of my repository i got 4 fact:
1) sum(days_a) days_a
2) sum(days_b) day_b
3) (case when days_a - days_b > 180 then 'J' else 'N' end ) indicator OM&ZM
4) total_sales
When i try to create the following answer (I want to have a filter directly on the column)
FILTER(Meetwaarden."total_sales" USING "- Indicatoren"."indicator OM&ZM = 'N')
But then i get the following error: [nQSError: 22034] Aggregate is not allowed within USING clause of a FILTER operator
I think the error is because of the sum on fact 1 and 2. But i'm not sure. Anyone know how i can use the filter / using clause with Aggregate objects.
tnx in advanced...