title: Using SSRS expression as a variable
body: <p>I am trying to use a expression within an expression in SSRS and it's getting really complicated. Is there a way around this?</p>
  
  <p>For example if I have a number of sales and number of contacts I can create the conversion rate by dividing the sales into the contacts ie</p>
  
  <pre><code>=fields!sales.value/fields!contacts.value
  </code></pre>
  
  <p>What I want to do next is use this to put the sales people into various bands so that those with a conversion rate in thresholds are displayed in bandings.</p>
  
  <pre><code>=iif(fields!sales.value/fields!contacts.value&lt;0.5,"poor","Ok")
  </code></pre>
  
  <p>This is fine for 2 bandings (ok and poor), but gets more complicated for the 5 bandings I want.</p>
  
  <p>I must be able to define the first variable and then use that within the iif statement? </p>
  
  <p>How do I do this in SSRS 2008?</p>
  
  <p>Thanks in advance.</p>