SRS Total not calculating correctly

See screen shot.  

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

Screen Shot
CPA_MCSEAsked:
Who is Participating?
 
CPA_MCSEConnect With a Mentor Author Commented:
Abandoning this question.  Report requirements changed.
0
 
ibbz-auCommented:
Try =Sum(DISTINCT()). Function
0
 
CPA_MCSEAuthor Commented:
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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

 
sureshbabukrishCommented:
are you using matrix or a tablix or a table?  the columns are dynamic or static?
0
 
sureshbabukrishCommented:
do one thing, in sql use Isnull(Revenue_Amt,0) instead of just Revenue_Amt.
0
 
CPA_MCSEAuthor Commented:
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
 
sureshbabukrishCommented:
can you send the rows (data) which your query pulls?
0
 
CPA_MCSEAuthor Commented:
Abandoning this question.  Report requirements changed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.