title: Web Intelligence report error. #MULTIVALUE error
body: <p>I've run into an issue with the WEBI report I am making. Here is the code in question:</p>
  
  <pre><code>=If([Group Change Task Status Desc] = "Open")
  Then([Count of GCT])
  ElseIf([Group Change Task Status Desc] = "Complete"  And [SH Open Date Actual Dt] &gt;= [Current Date - 60] And [SH Open Date Actual Dt] &lt;= [Current Date])
  Then([Count of GCT])
  </code></pre>
  
  <p>This is very basic and straight forward code. Count the O's and count the C's when they fall between the two dates.</p>
  
  <p>This is the error I'm getting:</p>
  
  <pre><code>Formula Evaluation - Error in 
  dataset values : #MULTIVALUE 
  Check formula definition in this 
  dataset context
  </code></pre>
  
  <p>I've determined the error is because of this part of the code:</p>
  
  <pre><code>And [SH Open Date Actual Dt] &gt;= [Current Date - 60] And [SH Open Date Actual Dt] &lt;= [Current Date]
  </code></pre>
  
  <p>I've tried it without this line and I get no errors. But the obvious problem is that I get too much data counted for the C's.</p>
  
  <p>I hope I provided enough info. Like I said, its pretty straight forward code. But this is my first time using WEBI and I need more experienced eyes on it.</p>