title: Calculated Field to Count While Between Dates
body: <p>I am creating a Tableau visualization for floor stock in our plant. We have a column for incoming date, quantity, and outgoing date. I am trying to create a visualization that sums the quantity but only while between the 2 columns. </p>
  
  <p>So for example, if we have 9 parts in stock that arrived on 9/1 and is scheduled to ship out on 9/14, I would like this visualization to include these 9 parts in the sum only while it is in our stock between those 2 dates. Here is an example of some of the data I am working with.</p>
  
  <p>4/20/2018   006         5/30/2018</p>
  
  <p>4/20/2018   017         5/30/2018</p>
  
  <p>4/20/2018   008         5/30/2018</p>
  
  <p>6/29/2018   161         9/7/2018</p>