title: Issue in Comparing two strings using report level variable- SAP BO
body: <p>I have a scenario where in i need to compare data of two columns. Both columns are Strings. 
  below are the scenarios to be covered </p>
  
  <p>Scenario 1 : if column 1 has a value and Column 2 is NULL = its a Mismatch </p>
  
  <p>Scenario2 : if column 1 is NULL and Column 2 has a Value = its a Mismatch</p>
  
  <p>Scenario 3 : if column 1 has a value and its found in Coulmn 2 (any position in set of strings) =Not a Mismatch </p>
  
  <p>Scenario4 : if column 1 value matches with Column 2 value= its not a Mismatch </p>
  
  <p>Scenario 5: If both columns are NULL = its not a mismatch </p>
  
  <p><img src="https://i.stack.imgur.com/vMNqE.jpg" alt="Expected output image"></p>
  
  <p>Note : I have tried to achieve the above scnerios by creating a report level variable and have defined as below </p>
  
  <pre><code>if (IsNull([column1)) then "Y" 
  else 
  If(Match([column1];"*[column2]*");"Y";"N") 
  </code></pre>
  
  <p>The above logic holds good for scenario 2,3,5 but do not cover the rest </p>
  
  <p>I use SAP BusinessObjects BI Platform 4.1 Support Pack 6 Patch 4 
  Version: 14.1.6.1848 </p>