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. Image for the cookie policy date

Using Formulas for summary rows - excluding custom summary implementation

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

1 Reply

Administrator 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.
Loader.
Live Chat Icon For mobile
Up arrow icon