IF FIELD IS BLANK, PRINT ANOTHER FIELD 1

[AMHCLH]

I have created a formula field to print a field called Short Item if it isn't blank; otherwise, I want the field Item to print. This is my formula
If ({BIDDTL.ShortItem}=" &quot Then {BIDDTL.Item} Else {BIDDTL.ShortItem}

It works to print the Short Item when it is filled, but when Short Item field is blank, nothing prints.

 

[MJRBIM]

You should check the data source.

The ({BIDDTL.ShortItem} string may be NULL and therefore is not equal to ' '.

 

[AMHCLH]

Thanks for responding. I changed the formula to check for null as well, but I still don't get any value to print.

If ({BIDDTL.ShortItem}<>&quot;&quot; And {BIDDTL.ShortItem}<> &quot; &quot Then {BIDDTL.ShortItem} Else {BIDDTL.Item}

 

[mbarron]

But a null check in your formula:

If isnull({BIDDTL.ShortItem}) or {BIDDTL.ShortItem}=&quot; &quot;
Then {BIDDTL.Item} Else {BIDDTL.ShortItem}


I also noticed you have a single space in the quotes (&quot; &quotinstead of &quot;&quot;.



Mike

 

[mbarron]

That should have been &quot;Put a null.. &quot;

I didn't read your first post corretly.
Mine formula should have been:


If not(isnull({BIDDTL.ShortItem})) or {BIDDTL.ShortItem}<>&quot; &quot;
Then {BIDDTL.Item} Else {BIDDTL.ShortItem}


Mike

 

[AMHCLH]

Thanks! It works now. Gave you a star.