title: Multiple IF statement in SSRS
body: <p>How to write multiple if statement in SSRS. I have written like this.</p>
  
  <pre><code>=IIf(Parameters!MyDuration.Value="ThisMonth" &amp; Parameters!Transactions.Value="Sale", Sum(Fields!ThisMonthSal), True,False)
  </code></pre>
  
  <p>this is throwing an exception that multiple parameter used. Please guide me how to write this multiple if statement. </p>