How to use TextBox item to combine generate the value of AVG automaticly ?

[Mars]

A	10
	20
A Total	30	AVG	0.25 (30/120)
B	20
	30
	40
B Total	90	AVG	0.75(90/120)
Total	120

Hello Sir,

I've a problem,
Above sample is a group like Report
The row of A Total and B Total are calculated(Sum) in TextBox control,
I want to use the row of  A Total and B Total to combine generate the value of AVG column automaticly as above sample.
How shoud I do ?
Pls help me,thanks :)

Regards.

[Peter]

Hello Victor Wang,

You can calculate the described average with an Exec(scope, expression) built-in function - it executes the specified expression in the given data scope. Used mostly with aggregate expressions as a second parameter; this function allows changing of the data scope in which the expression is evaluated. Scope parameter is the name of the data scope we need to evaluate the expression against.

Your expression should look like this one:
= Sum(Fields.Price)/Exec("Table1",Sum(Fields.Price))

Best wishes,
Peter
the Telerik team