Solved

SRS Total not calculating correctly

Posted on 2011-03-22
8
944 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
  • 4
  • 3
8 Comments
 

Expert Comment

by:ibbz-au
Comment Utility
Try =Sum(DISTINCT()). Function
0
 

Author Comment

by:CPA_MCSE
Comment Utility
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
Comment Utility
are you using matrix or a tablix or a table?  the columns are dynamic or static?
0
 
LVL 9

Expert Comment

by:sureshbabukrish
Comment Utility
do one thing, in sql use Isnull(Revenue_Amt,0) instead of just Revenue_Amt.
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:CPA_MCSE
Comment Utility
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
Comment Utility
can you send the rows (data) which your query pulls?
0
 

Accepted Solution

by:
CPA_MCSE earned 0 total points
Comment Utility
Abandoning this question.  Report requirements changed.
0
 

Author Closing Comment

by:CPA_MCSE
Comment Utility
Abandoning this question.  Report requirements changed.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now