iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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.
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
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.
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).
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname
Creating your account...