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.
Unfortunately, activation email could not send to your email. Please try again.

Summary Rows and NaN values - How can I automatically exclude values

Thread ID:

Created:

Updated:

Platform:

Replies:

21737 Nov 18,2004 11:59 AM Nov 18,2004 03:51 PM Windows Forms 1
loading
Tags: GridControl
Colin Marsh
Asked On November 18, 2004 11:59 AM

Using a GroupingGridControl I have a summary row. One of the columns is an average value and therefore when the values used to calculate the average are zero, I get the "NaN" value displayed. Whenever a NaN value is calculated I display zero by adding an event handler to: mSummaryGrid.TableControlDrawCellDisplayText and changing the text to zero. NaN values screw up the summary row cell though. So if the summary cell is and average of all values in the Column. I get Nan in the summary cell if any row contains a Nan in that column. Is there a setting to exclude NaN values from summary cell calculations so that I get a summary of the valid values? Or do I have to implement the "custom" summary type?

Administrator [Syncfusion]
Replied On November 18, 2004 03:51 PM

Hi Colin, I see two options. You could either do a custom summary or you do a unbound field. With a unbound field you could handle QueryValue and SaveValue yourself and store/retrieve data from the underlying data (record.GetData()) and swap out the Nan field with ''0'' or DbNull. Stefan

CONFIRMATION

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.

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.

;