Hi
I have a below map. I want to sum up the amount if the Activity Code,TransCode,PostNumber,EffectiveDate and ReversalCode is the same. Can someone help
map is in
jsp : {29=
{ActivityName=CONTRIBUTION, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=60.0, ReversalCode=No, Seq=2, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X1E}, 49={
ActivityName=SA UNITS PURCH, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=60.0, ReversalCode=No, Seq=6, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 39={ActivityName=CONTRIBUTION, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=40.0, ReversalCode=No, Seq=5, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X9E}, 24={ActivityName=SA UNITS PURCH, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=60.0, ReversalCode=No, Seq=6, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 50={ActivityName=CASH EARNINGS, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=8.55, ReversalCode=No, Seq=7, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=2, FundId=T4E}, 23={ActivityName=CONTRIBUTION, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=40.0, ReversalCode=No, Seq=5, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X9E}, 34={ActivityName=UNDEFINED ACTVY, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=200502.28, ReversalCode=No, Seq=7, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=299, FundId=T4E}, 30={ActivityName=CONTRIBUTION, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=120.0, ReversalCode=No, Seq=3, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X2E}, 18={ActivityName=UNDEFINED ACTVY, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=200412.29, ReversalCode=No, Seq=46, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=299, FundId=T4E}, 20={ActivityName=CONTRIBUTION, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=60.0, ReversalCode=No, Seq=2, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X1E}, 42={ActivityName=SA UNITS PURCH, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=8.52, ReversalCode=No, Seq=45, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 25={ActivityName=CASH EARNINGS, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=10.93, ReversalCode=No, Seq=7, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=2, FundId=T4E}, 32={ActivityName=CONTRIBUTION, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=40.0, ReversalCode=No, Seq=5, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X9E}, 43={ActivityName=UNDEFINED ACTVY, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=200503.31, ReversalCode=No, Seq=47, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=299, FundId=T4E}, 35={ActivityName=CONTRIBUTION, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=60.0, ReversalCode=No, Seq=1, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=T4E}, 13={ActivityName=CONTRIBUTION, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=120.0, ReversalCode=No, Seq=4, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X6E}, 26={ActivityName=SA UNITS PURCH, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=10.93, ReversalCode=No, Seq=45, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 44={ActivityName=CONTRIBUTION, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=60.0, ReversalCode=No, Seq=1, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=T4E}, 9={ActivityName=UNDEFINED ACTVY, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=200411.3, ReversalCode=No, Seq=45, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=299, FundId=T4E}, 19={ActivityName=CONTRIBUTION, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=60.0, ReversalCode=No, Seq=1, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=T4E}, 28={ActivityName=CONTRIBUTION, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=60.0, ReversalCode=No, Seq=1, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=T4E}, 3={ActivityName=CONTRIBUTION, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=120.0, ReversalCode=No, Seq=3, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X2E}, 41={ActivityName=CASH EARNINGS, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=8.52, ReversalCode=No, Seq=7, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=2, FundId=T4E}, 27={ActivityName=UNDEFINED ACTVY, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=200501.31, ReversalCode=No, Seq=47, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=299, FundId=T4E}, 14={ActivityName=CONTRIBUTION, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=40.0, ReversalCode=No, Seq=5, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X9E}, 17={ActivityName=SA UNITS PURCH, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=10.15, ReversalCode=No, Seq=44, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 36={ActivityName=CONTRIBUTION, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=60.0, ReversalCode=No, Seq=2, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X1E}, 6={ActivityName=SA UNITS PURCH, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=60.0, ReversalCode=No, Seq=6, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 1={ActivityName=CONTRIBUTION, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=60.0, ReversalCode=No, Seq=1, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=T4E}, 5={ActivityName=CONTRIBUTION, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=40.0, ReversalCode=No, Seq=5, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X9E}, 16={ActivityName=CASH EARNINGS, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=10.15, ReversalCode=No, Seq=7, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=2, FundId=T4E}, 46={ActivityName=CONTRIBUTION, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=120.0, ReversalCode=No, Seq=3, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X2E}, 37={ActivityName=CONTRIBUTION, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=120.0, ReversalCode=No, Seq=3, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X2E}, 33={ActivityName=SA UNITS PURCH, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=60.0, ReversalCode=No, Seq=6, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 15={ActivityName=SA UNITS PURCH, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=60.0, ReversalCode=No, Seq=6, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 11={ActivityName=CONTRIBUTION, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=60.0, ReversalCode=No, Seq=2, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X1E}, 40={ActivityName=SA UNITS PURCH, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=60.0, ReversalCode=No, Seq=6, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}, 4={ActivityName=CONTRIBUTION, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=120.0, ReversalCode=No, Seq=4, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X6E}, 12={ActivityName=CONTRIBUTION, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=120.0, ReversalCode=No, Seq=3, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X2E}, 45={ActivityName=CONTRIBUTION, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=60.0, ReversalCode=No, Seq=2, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X1E}, 7={ActivityName=CASH EARNINGS, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=2.44, ReversalCode=No, Seq=7, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=2, FundId=T4E}, 38={ActivityName=CONTRIBUTION, TradeDate=03/31/2005, RunDate=03/31/2005, Cash=120.0, ReversalCode=No, Seq=4, PostNum=23, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X6E}, 2={ActivityName=CONTRIBUTION, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=60.0, ReversalCode=No, Seq=2, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X1E}, 31={ActivityName=CONTRIBUTION, TradeDate=02/28/2005, RunDate=03/02/2005, Cash=120.0, ReversalCode=No, Seq=4, PostNum=21, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X6E}, 47={ActivityName=CONTRIBUTION, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=120.0, ReversalCode=No, Seq=4, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X6E}, 21={ActivityName=CONTRIBUTION, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=120.0, ReversalCode=No, Seq=3, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X2E}, 48={ActivityName=CONTRIBUTION, TradeDate=04/29/2005, RunDate=04/29/2005, Cash=40.0, ReversalCode=No, Seq=5, PostNum=24, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X9E}, 10={ActivityName=CONTRIBUTION, TradeDate=12/29/2004, RunDate=12/29/2004, Cash=60.0, ReversalCode=No, Seq=1, PostNum=19, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=T4E}, 22={ActivityName=CONTRIBUTION, TradeDate=01/31/2005, RunDate=01/31/2005, Cash=120.0, ReversalCode=No, Seq=4, PostNum=20, TranCode=114 Part Cntrb Dtl, Activity=1, FundId=X6E}, 8={ActivityName=SA UNITS PURCH, TradeDate=11/30/2004, RunDate=11/30/2004, Cash=2.44, ReversalCode=No, Seq=43, PostNum=18, TranCode=114 Part Cntrb Dtl, Activity=95, FundId=T4E}}
