Is it possible to show null values in cross tab reports?

Ingo Klose shared this question 3 years ago
Answered

Hi,


From what I can see, cross tab reports assume a 0 for missing values in the data. Is there a way to surpress that and display an empty cell?


Many thanks and best regards,

Ingo

Comments (5)

photo
1

Hi Ingo,


Thank you for getting in touch. This ability to display null values as zero can be toggled within the "column formatting" menu as seen below.


054dbfa8f8a4a123bf34b806f8b87019


Please let me know if this does not work for you, or if you have any additional questions relating to this issue.


Regards,

Nathan

photo
1

Hi Nathan,


in our report this option seemed to have no effect. I will investigate a bit further and let you know if I need more help.


Best regards,

Ingo

photo
1

Hi Ingo,


I was just wondering if you have had any luck in resolving this issue? Please let me know if you have any additional questions, or if you would be okay with me closing this ticket.


Regards,


Nathan

photo
1

Hi Nathan,


Unfortunately I did not get around doing any more testing. If I do, I will let you know.


Best regards,

Ingo

photo
1

Hi Ingo,

I am going to close this ticket for now. If you run into any issues, just reply and the case will be re-opened!

Regards,

Nathan