Steema Central

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

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.

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

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.