title: SSRS Conditional Exprssn
body: <p>Please help me to solve this issue.
  I am new to SSRS.</p>
  
  <p>I am trying to sum up the <code>Amount (w/o Tax)</code> based on different product categories like <code>AEC,MCL,MFG</code> &amp; so on..
  I used IIF &amp; Sum Conditions but it throws an error.</p>
  
  <p>Here I have pasted the conditional expression plz go through it.</p>
  
  <pre><code>=IIf(((Fields!Prod_Horz_Category.Value="AEC",sum(Fields!Amt_w_o_Tax.Value)),IIf(Fields!Prod_Horz_Category.Value="ASB",sum(Fields!Amt_w_o_Tax.Value),IIf(Fields!Prod_Horz_Category.Value="MCL",sum(Fields!Amt_w_o_Tax.Value),IIf(Fields!Prod_Horz_Category.Value="ME",sum(Fields!Amt_w_o_Tax.Value),IIf(Fields!Prod_Horz_Category.Value="MFG",sum(Fields!Amt_w_o_Tax.Value),IIf(Fields!Prod_Horz_Category.Value="TRG",sum(Fields!Amt_w_o_Tax.Value),IIf(Fields!Prod_Horz_Category.Value="SUB",sum(Fields!Amt_w_o_Tax.Value),0))
  </code></pre>