Intersoft Community - WebGrid Enterprise - WebGrid calculations on Footer

WebGrid calculations on Footer

handy@intersoftpt.com — Tue, 31 Aug 2010 02:55:21 GMT

Hello Ben,

Unfortunately, there is no properties or variabel to store the footer total of another column. Except, if you also calculate the total of that column manually by using custom aggreagate.

Regards,
Handy

WebGrid calculations on Footer

bdenison — Mon, 30 Aug 2010 12:21:39 GMT

Thanks, but is there a way to get the total one or more columns (in the footer) and use it in the total of another column total (in the footer).

WebGrid calculations on Footer

handy@intersoftpt.com — Thu, 26 Aug 2010 17:22:55 GMT

Hello Ben,

If you don't want it to be handled in every FlyPostBack, you need to handle your custom aggregate in CustomAggregate server side event.
Please open our WebGrid documentation/references and search for Using Custom Aggregate function in WebGrid.
Hope this helps.

Regards,
Handy

WebGrid calculations on Footer

bdenison — Thu, 26 Aug 2010 13:03:06 GMT

I have a webgrid that has 4 columns as follows:

Col1 = Value

Col2 = Value

Col3 = Value

Col4 = (Col1+Col3)/(Col1+Col2)

I am using the Aggregate property to get the sum of Col1, Col2, Col3 and display these on the Footer. How do I get Col4 to show the following formula?

(Sum(Col1)+Sum(Col3))/(Sum(Col1)+Sum(Col2))

I tried using the Custom Aggregate property but it looks as if I have to sum the other columns on the fly. Not very efficient.