Solved

Aggregate in SSRS reports

Posted on 2012-03-21
2
360 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

Title # Comments Views Activity
Sum Of Group In SSRS Report 18 96
Show report sections based on expression 7 47
Date Differences SSRS 3 75
Change the SSRS datasource server or connection string 10 58
Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

828 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