title: Nested CASE WHEN Formula(text) in Saved Search Results in NetSuite
body: <p>I have two fields <code>_courier</code> and <code>_trackingnumber</code>.
  I would like to create in results nested CASE WHEN formula (text) under the following conditions:</p>
  
  <ol>
  <li>the courier is = 'NAME'
  and</li>
  <li>if the <code>_trackingnumber</code> of this courier does not start with <code>0</code> then add <code>00</code> else add <code>_trackingnumber</code> <code>&amp;</code></li>
  </ol>
  
  <p>I have tried this CASE WHEN option and I realize that AND  function does not exist in Functions list in Netsuite</p>
  
  <pre><code>CASE WHEN {_courier} = 'NAME' AND ({_trackingnumber},'0'THEN ('00' || {_trackingnumber}) ELSE ('&amp;' || {_trackingnumber}) END
  </code></pre>
  
  <p>And I got this error message:</p>
  
  <blockquote>
    <p>I got this error: <strong>ERROR: Invalid Expression</strong></p>
  </blockquote>
  
  <p>Can you please advise how to fix it?</p>