CPA_MCSE
asked on
SRS Total not calculating correctly
Try =Sum(DISTINCT()). Function
ASKER
Thanks for the reply. That threw out an error.
Tried both
=Sum(DISTINCT(Fields!Reven ue_Amt.Val ue))
=Sum(DISTINCT((Fields!Reve nue_Amt.Va lue)))
Capture.JPG
Tried both
=Sum(DISTINCT(Fields!Reven
=Sum(DISTINCT((Fields!Reve
Capture.JPG
are you using matrix or a tablix or a table? the columns are dynamic or static?
do one thing, in sql use Isnull(Revenue_Amt,0) instead of just Revenue_Amt.
ASKER
Thank you for the replies. This is a table report, not a matrix. Adding Isnull is fine, but does not affect the report totals.
can you send the rows (data) which your query pulls?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Abandoning this question. Report requirements changed.