IF-THEN-ELSE EASY QUESTION

[Guest_imported]

This is an inserted formula field. @t_f
This seems very simple! If the first set of conditions is met, I get "T" as expected however, if they ar not met, I get a blank instead of "F" Any ideas why?
IF
{Pre Case.PROVIDER ID} = {Preference Header.PROVIDER ID} AND
{Preference Header.DELETE FLAG} <> &quot;X&quot; and
{Pre Case.MAIN PROCEDURE ID} = {Preference Header.PROCEDURE ID}
THEN
&quot;T&quot;
ELSE
&quot;F&quot;

 

[kenhamady]

Probably a null value in one of the fields.
If any field in the formula is null on that record, the formula will return null.

Try the menu options File-Report Options
and check off &quot;Convert Null field to default&quot;.


Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal