UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sum Once For Each Instance Of Account Number, XI    
 
   
Dexter
post Jun 29 2016, 03:41 PM
Post#1



Posts: 624
Joined: 5-November 07



On my crystal report, I have an account number, account holder name, the status, the date of the account, and the total commitment amount. Because an account number can have multiple status, I grouped the report by account number and then by account holder name. Everything was looking great until I tried to create a sum for each account holder of the commitment amount. It seems to be adding every instance of the account number for the multiple status together in the totals. How do I get it to add the commitment amount only once per account number? I unfortunately need status on the report.

Thanks!
Go to the top of the page
 
ranman256
post Jul 1 2016, 10:49 AM
Post#2



Posts: 786
Joined: 25-April 14



bring [status] into the query as groupby
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    13th December 2017 - 12:27 AM