If a value is null I want my text to display 'N/A'

[crushin]

I have a text field that receives a numeric value. I have a conditional set on the field to display the value in different colors depending on the number. If it is returned as Null, I'd like to be able to display 'N/A.' I thought this would be as simple as setting a conditional where if the value is null to assign the expression 'N/A'. With this condition in place it still displays a 0. How can I fix this?

[Lech Kulikowski]

Hello,

You can use the following expression:
{IIF(source.column == null, "N/A", source.column)}

Also, you should set the ConvertNulls property for the report to false.

Thank you.

[crushin]

This did not work. null is still being converted to 0. if I put {IIF(null == null, "N/A", source.column)} it works. It doesn't seem to be interpreting null correctly.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.