Printing N/A on report

[twes3]

Hi,

I am using Crystal Reports 10.
I am trying to display 'N/A' on a formula field. Here is my formula:

If
{v_test.exception_flag} = 'N' then {v_test.inv_onhand_qty}

else

'N/A'

I keep getting an error message that 'NA' is not numeric. Any suggestions???

 

[Turkbear]

Hi,
The results of an IF test must be of the same type, so convert your {v_test.inv_onhand_qty} field using the ToText function

If
{v_test.exception_flag} = 'N' then ToText({v_test.inv_onhand_qty})

else

'N/A'

To Paraphrase:"The Help you get is proportional to the Help you give.."