Help - data type error in IF formula

[encwgwg]

The following is the formula I wrote for Business Objects report:
=If <Variable1> = 0 Then "NA" Else <Variable 2)/<Variable 3>

It returns error message "Incorrect Data Type DMB0003".

It looks like the formula syntax doesn't like the character string "NA" to be used together with numeric result of <Variable 2>/<Variable 3>.

How should I handle this?

Thanks a lot.
Kevin. W.

 

[briangriffin]

Is this a Crystal Report, or Business Objects Desktop Intelligence?

 

[scottostanek]

The "NA" sets the output type to string. To still use it you would need to change the second part to a string or the first part to a number.

=If <Variable1> = 0 Then "NA" Else <Variable 2)/<Variable 3>
becomes either {stringver}
=If <Variable1> = 0 Then 0 Else <Variable 2)/<Variable 3>
//if you use this case I would suppress 0
or
{numberver}
=If <Variable1> = 0 Then "NA" Else ToText((<Variable 2)/<Variable 3>),0,"")

Scotto the Unwise
and yes I do know this one from my own burned fingers

 

[encwgwg]

Thanks guys,
my formula is for Business Objects Desktop Intelligence.
Thanks.
Kevin.W.