Crosstab: show character in place of NULL/Zero value

[cmcfusion]

Is it possible to display a specified character in a crosstab when the value is NULL/zero? Similar to the option that exists on a data field. Here's an example of how output currently appears and how I'd like it to appear.

Crosstab current.jpg (7.98 KiB) Viewed 1467 times

Crosstab wanted.jpg (8.53 KiB) Viewed 1467 times

Thanks,
Sabrina

[HighAley]

Hello.

Yes, it's possible. You could do this with Conditions.
Check if value == 0 and Assign the expression.

value0.png (12.93 KiB) Viewed 1462 times

Thank you.