Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Aggregate in SSRS reports

Posted on 2012-03-21
2
Medium Priority
?
367 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

971 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