Showing N/A in a cross tab when Null Value

[Former Member]

Hi,

If in cross tab the intersection results in a "null" valuie is there a way as part of formatting a field we can make N/A display?

Thanks,

[abhilash_kumar · Accepted solution]

Hi Leo,

Right-click one of the cells in the Summary fields > Select Format field > Common tab > Click on the formula button beside 'Display String' and use this code:

if currentfieldvalue = 0 then "N/A"

else

totext(currentfieldvalue)

-Abhilash