My multiple expression doesn't quite work.

[#1]

Hey, my current expression looks like this:

Sum(Aggr(IF(Sum({<[Kontonummer]>} [Bokfört belopp]) < 0,Sum([Bokfört belopp]) * Sum([Andel av kapital])), [ID-nummer], [Kontonummer]))

And it's primary job is to multiple [bokfört belopp] with [Andel av kapital] and to sum a total of the outcome at the top.

My problem is now that the multiple function doesn't quite work, as you can see here...

Would really appreciate if someone could help me with this issue.

Kind Regards

D.Z

[#2]

The multiple function works on the "regular" values but not on the total as it seems...

[jonas_rezende]

Hi, Daniel Zlokapa.

Ensure that all dimensions are [ID-nummer], [Kontonummer]. Otherwise, you have to include in AGGR() function.

Hope this helps!