Where is the - in the second line of the header coming from?

[jimgibson]

Based on the attachment, could someone please tell me where the - is coming from in the second row of the header? The - is set as the substitute for null values but there are no null values being loaded in from the DatapointDefinitions table.  And how would I fix it?

Thanks

[trdandamudi]

I used a Table box chart and i don't see the ' - '. Please take a look at the attached file. What chart are you using ?

Hope this helps...

[swuehl]

You are probably using just the field name as expression, which is equal to

=Only( Description )

This expression won't return a unique answer in the total line (second row), hence return NULL.

Try to use:

=Concat( DISTINCT Description,', ')

or disable the total for this expression.

Use Aggregation Functions!

[jimgibson]

Swuehl you are correct again.  Thank you very much.  I normally do use Table Boxes for these types of things but I don't believe you can put a calculated field in a Table Box so I was forced to use a Straight Table.

Your answer rescued me again.  Thanks

Jim