Aggregation evaluation in Set Analysis

swazi001 — Tue, 24 Sep 2019 16:20:06 GMT

I am trying to perform a group by and evaluate the result in an expression. This would be a simplified version of what I am trying to achieve:

=sum( {<[Aggr(sum(amount),value_A, value_B)]={"<0"}>} amount)

In this expression as I have it, the <0 is ignored and the sum of all values grouped by A and B is returned.

Any suggestions?

Re: Aggregation evaluation in Set Analysis

Lauri — Thu, 26 Sep 2019 21:34:18 GMT

Is [Aggr(sum(amount),value_A, value_B)] the name of a dimension? If it isn't, then the set analysis won't work. You can only use dimensions.