TDBChart summary null values

Thomas Klingler · Post by **Thomas Klingler** » Fri Nov 02, 2007 1:20 pm

Hi,

When I use a DBchart with the summary avg function on a field, null values are taken in the computation yielding false results.
Is there a way to ignore null values?

TIA

Markus

Teechart 7.12

Narcís · Post by **Narcís** » Mon Nov 05, 2007 8:14 am

Hi Markus,

Yes, you can set IncludeNulls property to false as shown in the All Features\Welcome!\Functions\Standard\Average\Average and nulls example in the features demo, available at TeeChart's program group.

Thomas Klingler · Post by **Thomas Klingler** » Mon Nov 05, 2007 12:04 pm

Hi Narcís,

thanks for your reply, but this is not what I was looking for. Rereading my question I have to admit that it was not quite clear. So here again my problem:

I use a DBChart with a Clientdataset as the value source. If I choose summary from the dropdown menu I can select different summaries from the dropdown menu in the editor (sum, count, high, low, avg). When I choose avg of one field grouped by another field, then NULL values go into that computation leading to false results. Hence my question if I can tell the series to ignore NULL values when computing the average.

Markus

Post by **Pep** » Fri Nov 09, 2007 11:48 am

Hi Markus,

yes, this feature has not been yet implemented, it's on our wish list as a feature request to be considered for further releases.
In meantime the only workaround I can think of would be to calculate the summaries manually.