title: Conditional statements using HANA SQL Script
body: <p>I have a table in HANA studio, which consists of 5 columns:</p>
  
  <ul>
  <li><code>item</code></li>
  <li><code>value</code></li>
  <li><code>cost</code></li>
  <li><code>Margin</code></li>
  <li><code>ABC_cat</code></li>
  </ul>
  
  <p>How can I generate a 6th column as <code>Margin Categorization</code>, using an if-else condition?</p>
  
  <pre><code>IF ((([Margin])/[VALUE])*100&lt;((SUM([VALUE])-SUM([COST]))/SUM([VALUE]))*100)
    THEN ('BELOW') 
    ELSE ('ABOVE')
  </code></pre>