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

[Colin Marsh]

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]

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