Hi all,
 I am fairly new with CR 11 and doing a lot of learning along the way. I have a report that is pulling some numerical fields from two different tables. One of the tables is an optional field and may or may not have a number connected to a record. I will try to diagram below. What I am finding if is there is no record in the second table I am not getting a value from my formula instead of just getting the value from table 1. How can I setup my formula so if no record exists in table 2 then use the value from table one as the result.


current Delima
Record ID      Table1            Table2           formula             result

1                        5                  3              Table1+table2         8
2                        6                                                                 
3                        9                                                                       
4                        4                   10                                          14

Would like to achieve the following:

Record ID      Table1            Table2           formula             result

1                        5                  3              Table1+table2         8
2                        6                                                                  6
3                        9                                                                  9    
4                        4                   10                                          14

Thanks for any help.

Flanman

Thank You very much. That worked great. I was working with the is null syntax but could not get it right until your example.

Flanman