title: IF statement equivalent in Google Data Studio
body: <p>I am trying to replicate the Excel formula
  <code>IF(AND('cost'&gt; 0, 'orders' = 0),&quot;TRUE&quot;)</code> in Google Data Studio using the <code>CASE</code> statement:</p>
  <pre><code>CASE
    WHEN COST &gt; 0 AND ORDERS = 0 THEN &quot;TRUE&quot;
  END
  </code></pre>
  <p>However, I receive the following error:</p>
  <blockquote>
  <p><em>Only numeric literals are allowed if aggregated fields are used in CASE</em></p>
  </blockquote>
  <p>Is there a way I can fix this?</p>