Solved

Aggregate in SSRS reports

Posted on 2012-03-21
2
357 Views
Last Modified: 2012-06-21
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
Comment
Question by:CodingSucks
  • 2
2 Comments
 

Accepted Solution

by:
CodingSucks earned 0 total points
ID: 37748035
Issue solved By using expression  =Avg(CDec(Fields!.NormSpeed.value))
0
 

Author Closing Comment

by:CodingSucks
ID: 37748043
String need to be converted to decimal
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question