Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.