Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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.
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