Joined: 01 Mar 2011
Location: United States
Online Status: Offline
Posts: 30
Topic: Sum of Group Distinct Posted: 04 Apr 2011 at 8:44am
How do I sum a group of only distinctcount records? This is for a security holdings report...I have some securities that have been purchased on multiple dates which I need to sum, but the others without multiple dates I don't need to sum.
The example of what I talking about is below...how do I surpress the BAC & CAT sum, but keep the BWA & CMI sum's? Thanks.
Joined: 01 Mar 2011
Location: United States
Online Status: Offline
Posts: 30
Posted: 04 Apr 2011 at 9:33am
I would like to surpress the row if the sum total is the same as what the qty amount is for what the Ticker group is. In other words, if the Ticker CAT is 100 for the single holding I don't also need another row that giving me the sum of 100. This sum row can just be surpressed. Is this possible to do? Thanks for your help!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum