title: Return Value first time condition is met
body: <p>I have a calculation, and I only want to return the left most value ie, the first time the condition is met.<img src="https://i.stack.imgur.com/hNf9b.png" alt="enter image description here"></p>
  
  <p>In the images it shows 95% 96% etc etc I only care for the column 5 where the condition of 95 is met.</p>
  
  <p>EDIT(more info)</p>
  
  <p>Ok so the percentages are calculated this way.</p>
  
  <pre><code>ROUND( RUNNING_SUM( SUM( [days_to_close_cnt] ) )/ SUM([newo_dt_cnt]),2 )
  </code></pre>
  
  <p>Using and the "Days to Close" gives me the column information.</p>
  
  <p>The Line graph looks like this.
  <img src="https://i.stack.imgur.com/TpWMM.png" alt="enter image description here"></p>
  
  <pre><code>if [% Completed] &gt;= .98  and  [% Completed] &lt; 1 then INT( 98 )
  elseif [% Completed] = 1  then INT(  1 )
  elseif  [% Completed] &gt;= .95  and [% Completed] &lt; .98 then INT( 95 )
  elseif  [% Completed] &lt; .95 and [% Completed] &gt;= .0 then INT(  0 )
  end
  </code></pre>
  
  <p>Is that calc I am using to color in this case.
  <img src="https://i.stack.imgur.com/jabE0.png" alt="enter image description here"></p>