Skip to Content
0
Former Member
Jun 05, 2013 at 12:00 PM

N/A - Null values in cross tab

143 Views

Hi,

In a cross tab I need the display value to be "N/A" if no value exists for the intersection as it current displays zero.

I have tried formatting the cell using the "Display String" function on the common tab with a formula:

if isnull(measure) then "N/A"

else measure

but it doesnt work. Any ideas?

Cheers,