We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Using Formulas for summary rows - excluding custom summary implementation

Thread ID:





25055 Feb 16,2005 09:17 PM UTC Feb 16,2005 11:30 PM UTC WinForms 1
Tags: Grouping
Asked On February 16, 2005 09:17 PM UTC

Can I do the following without using the CustomSummary facility (I find it difficult to implement). I am using three columns, col 1 is a value, col 2 is a total, col 3 is the percentage (i.e. col3 = col 1 / col 2). In my summary row, I would like Sum Col 3 = Sum Col 1 / Sum Col 2. I do not want to apply a SUM: formulat or AVERAGE: formula of the Column 3. Instead I want to summarize Cols 1 & 2 and then formula the col3 in the summary row. I know I can implement a custom formula, but was hoping a simple formula like this, did not have to go through the Custom Formula implementation. Thanks

Administrator [Syncfusion]
Replied On February 16, 2005 11:30 PM UTC

One way you can try to do this is to handle the QueryCellStyleInfo event, and if the cell being requested is your summary cell, then provide the value you want to see. Here is a sample that computes a weighted average summary using this technique.


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon