aggr for a sum / sum expression

[praijmakers]

Hello Everybody,

Please take a look at this example table:

Group	SubGroup	Value1	Value2	base expression = sum(Value1)/sum(Value2	Aggr(NoDistinct sum(Value1)/ sum(Value2), Group)	I want
A	A1	2	1	2	2	4
A	A2	4	2	2	2	4
B	B1	6	2	3	3,6	7
B	B2	12	3	4	3,6	7

So what i want is the sum of the results for the base expression per group. But the base expression is a sum() devided by sum() expression so the aggr of that leads to an average. This is a simplified example. The base expression can not be changed.

I tried using an expression label reference like: aggr( sum( [base expression] ), Group) but label references in aggr do not work.

Your help would be much appreciated.

Regards,

Peter

[vishsaggi]

Try this?

= Sum(TOTAL <Group> Value1/Value2)