title: Formula field displays blanks instead of desired result
body: <p>I'm stuck on a problem with a formula field in Crystal Reports and I keep going around in circles.  I'll try my best to explain it.</p>
  
  <p>The report I'm creating will be exported as a data file.  It uses 3 tables, with <code>work_table</code> as the main table.  <code>work_table</code> is joined to a view called <code>order_item_with_aux</code> using two fields, <code>orderhdr_id</code> and <code>order_item_seq</code>; it's an inner join.  I don't think this has much bearing on my problem but, <code>work_table</code> is also joined to the <code>customer_address</code> table on <code>customer_id</code> and <code>customer_address_seq</code>.</p>
  
  <p>In my output, I've included several fields from all three tables.  Where I'm stuck is creating a formula field to populate a <code>@Split</code> field.  Here's what I'm writing in my formula:</p>
  
  <pre><code>if {order_item_with_aux.zzaux_no_renewal_notices} = "Y" then "B"
  else {work_table.split_value}
  </code></pre>
  
  <p>This results in the <code>@Split</code> field being populated with "B" for records on the <code>work_table</code> whose corresponding record on the <code>order_item_with_aux</code> view has <code>zzaux_no_renewal_notices</code> equal to "Y".  The value of <code>@Split</code> for all other records displayed is blank.  I've tried several variations of the above formula all to no avail.  I've also tried setting a variable and handling it that way, but again, no go.</p>
  
  <p>Anyone have any ideas?  Please let me know if there's more info I can provide.</p>