I have a data in a tuple C# I will calcaulate the sum of the last column grouped by month. my program gives wrong results as shown in the table below.
july GBP 6000 13 400 19500 1500 5200 800
Data sum 800
july SAR 1000 2 400 1200 600 800 200
july USD 4500 8.95 500 15993 1787 4475 25
Data sum 1025
august USD 5700 8.5 600 5950 700 5100 600
The correct result should be like this
july GBP 6000 13 400 19500 1500 5200 800
july SAR 1000 2 400 1200 600 800 200
july USD 4500 8.95 500 15993 1787 4475 25
Data sum 1025
august USD 5700 8.5 600 5950 700 5100 600
data sum 600