title: Tableau Filter Formula
body: <p>I am trying to filter workgroup name that only contains BL or CL so I used the formula...</p>
  
  <pre><code>STARTSWITH([wrkgrp_shrt_nm], "BL") or STARTSWITH([wrkgrp_shrt_nm], "CL" )
  </code></pre>
  
  <p>I get the little green check, but when I hit apply it is blank and nothing pulls through</p>
  
  <p>I tried another formula...</p>
  
  <pre><code>if right([wrkgrp_shrt_nm],2) = 'BL' then 1 elseif
  right([wrkgrp_shrt_nm],2) = 'CL' then 1 elseif
  right([wrkgrp_shrt_nm],2) then 0
  end
  </code></pre>
  
  <p>but I am only getting an error</p>
  
  <p>any suggestions?</p>