title: SSRS Expression for color error
body: <p>I've got this expression for my percent column to work out which colour to use based on several column values in my SSRS report.</p>
  
  <pre><code>=IIF(Fields!GrossMarginActual.Value = 0 AND Fields!GrossMarginPercentageActual.Value = 0, 0, Fields!VarianceGrossMargin.Value) AND
  IIF(Round(Fields!VarianceGrossMargin.Value,2) &lt; 0.00, "Red", "Black")
  </code></pre>
  
  <p>However I get the following </p>
  
  <blockquote>
    <p>The color expression for the text run 'VarianceGrossMarginPercent.Paragraphs[0].TextRuns[0]' contains an error: [BC30205] End of Statement Expected.</p>
  </blockquote>
  
  <p>I am guessing my syntax on my expression isn't quite right. I've wrapped extra brackets round it but that just gives me back errors. This correct syntax doesn't flag up any errors in the expression box.</p>
  
  <p>Would appreciate a second pair of eyes to look over it.</p>