Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 966
  • Last Modified:

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
0
CPA_MCSE
Asked:
CPA_MCSE
  • 4
  • 3
1 Solution
 
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
 
sureshbabukrishCommented:
are you using matrix or a tablix or a table?  the columns are dynamic or static?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
CPA_MCSEAuthor Commented:
Abandoning this question.  Report requirements changed.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now