Solved

SRS Total not calculating correctly

Posted on 2011-03-22
8
952 Views
Last Modified: 2012-05-11
See screen shot.  

My total is not adding correctly for every column.  What do I need to change?

Screen Shot
0
Comment
Question by:CPA_MCSE
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 

Expert Comment

by:ibbz-au
ID: 35194290
Try =Sum(DISTINCT()). Function
0
 

Author Comment

by:CPA_MCSE
ID: 35194363
Thanks for the reply.  That threw out an error.

Tried both

=Sum(DISTINCT(Fields!Revenue_Amt.Value))

=Sum(DISTINCT((Fields!Revenue_Amt.Value)))

Capture.JPG
0
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 35197486
are you using matrix or a tablix or a table?  the columns are dynamic or static?
0
Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 35197495
do one thing, in sql use Isnull(Revenue_Amt,0) instead of just Revenue_Amt.
0
 

Author Comment

by:CPA_MCSE
ID: 35198655
Thank you for the replies.  This is a table report, not a matrix.  Adding Isnull is fine, but does not affect the report totals.

0
 
LVL 9

Expert Comment

by:sureshbabukrish
ID: 35199529
can you send the rows (data) which your query pulls?
0
 

Accepted Solution

by:
CPA_MCSE earned 0 total points
ID: 35378890
Abandoning this question.  Report requirements changed.
0
 

Author Closing Comment

by:CPA_MCSE
ID: 35410360
Abandoning this question.  Report requirements changed.
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

690 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