• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Aggregate in SSRS reports

Report
Hi,

I am trying to calculate Avg value by  Machine and by operator and by Color as shown in attached image. i am using Avg([NormSpeed]) but its showing me error in the column cell "#Error"

Thanks in Advance..

PN.
0
CodingSucks
Asked:
CodingSucks
  • 2
1 Solution
 
CodingSucksAuthor Commented:
Issue solved By using expression  =Avg(CDec(Fields!.NormSpeed.value))
0
 
CodingSucksAuthor Commented:
String need to be converted to decimal
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now