title: Report formular column showing object where not in object
body: <p>Im trying to filter a report in business objects,  </p>
  
  <p>Im mostly where I want to be from multiple queries being run and custom variable in the report. </p>
  
  <p>What Im struggling with is creating a column that displays [AccountID A] that is not in [AccountID B]</p>
  
  <p>these account ID's came from the same object but are different lists from the run queries </p>
  
  <p>example Formula attempt for column</p>
  
  <pre><code>    =[AccountID A] where ([AccountID A] &lt;&gt; [AccountID B])
  </code></pre>
  
  <p>This comes up with no entries however and I know from exporting and filtering my test batch in excel there are 3 ID's that should display. Also been attempting variations with NOT, and variation with INLIST with no luck so far, anyone able to suggest an approach?</p>