title: Netsuite - Saved Search with Days Calculation Formula
body: <p>![enter image description here][1]I am trying to create a Saved Search in Netsuite that calculates the number of days between two dates in a summarized search.  I am attaching a screenshot of the Results tab for reference.  I have tried using a Numeric Formula field, as well as a Date/Time Formula field.  I have also tried every Summary Type available.  Is there another way to do this?  I just get an entire blank column when I run this.</p>
  
  <p>As some background, I am trying to calculate how many days between when the system note was changed to Pending Accounting to when the system note was changed to Processed.</p>
  
  <p>Thanks!</p>
  
  <p>Update: It won't let me upload photos.  Here is the formula I am using: </p>
  
  <pre><code>(CASE WHEN {systemnotes.newvalue}
  = 'Processed'THEN {systemnotes.date} END)-(CASE WHEN {systemnotes.newvalue}
  ='Pending Accounting'THEN {systemnotes.date} END)
  </code></pre>