title: SQL Case Statement To Increment Value
body: <p>Trying to create a calculated column that would have a value based on the values in four other columns. 
  Column 1, Coulmn 2, Column 3, Column 4 could be either Yes or No
  The end result in the calculated column, let's say called Progress, should be something along this line:</p>
  
  <pre><code>Progress = CASE
  WHEN [Column1] = 'Yes' THEN Value+1
  WHEN [Column2] = 'Yes' THEN Value+1
  WHEN [Column3] = 'Yes' THEN Value+1
  WHEN [Column4] = 'Yes' THEN Value+1
  ELSE 0 END
  </code></pre>
  
  <p>Hope this makes sense as obviously the syntax for the above is not correct.</p>