title: Different "IF" statement for different outcomes in field - SSRS
body: <p>Good day,</p>
  
  <p>I am creating a report where I want to assign a unique <code>"IF"</code>statement depending on the variables in a field.</p>
  
  <p>For example, in a column, if a row displays <code>"MCAD"</code>, I want it to calculate this formula in the column next to it: </p>
  
  <pre><code>iif(Fields!jhapostingdate.Value&gt;"12/30/2016",(Sum(Fields!CurrentBalance.Value)-1803418)/6000000," ")
  </code></pre>
  
  <p>If the row displays <code>"RGAD"</code>, I want it to calculate this formula in the column next to it: </p>
  
  <pre><code>iif(Fields!jhapostingdate.Value&gt;"12/30/2016",(Sum(Fields!CurrentBalance.Value)-6977142)/10000000," ")
  </code></pre>
  
  <p>And so on and so forth....</p>
  
  <p>I understand the following expression is incorrect, but it might make my intentions clear to you all:</p>
  
  <pre><code>=iif(Fields!OfficerCode.Value="mcad",(iif(Fields!jhapostingdate.Value&gt;"12/30/2016",(Sum(Fields!CurrentBalance.Value)-1803418)/6000000," "),"")
  
  ,iif(Fields!OfficerCode.Value="rgad",(iif(Fields!jhapostingdate.Value&gt;"12/30/2016",(Sum(Fields!CurrentBalance.Value)-6977142)/10000000," "),"")
  
  ,iif(Fields!OfficerCode.Value="srf",(iif(Fields!jhapostingdate.Value&gt;"12/30/2016",(Sum(Fields!CurrentBalance.Value)-3427940)/3000000," "),"")
  
  ,iif(Fields!OfficerCode.Value="maf",(iif(Fields!jhapostingdate.Value&gt;"12/30/2016",(Sum(Fields!CurrentBalance.Value)-6977142)/10000000," "),"")
  </code></pre>
  
  <p>Is there a specific function or expression for this?</p>
  
  <p>Any input is appreciated!</p>