Sum of duplicated items Tuple C#

Hudikwebb IT

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.

The program is here :

var q1 = from x in Vinst
group x by x.Item1 into g
let count = g.Count()
orderby count descending
select new { Value = g.Key, Count = count};
double sum = 0.0;//= (from x in Vinst where x.Item1.Equals("augusti") select x.Rest.Item2).Sum();
int k = 0;
foreach (var lst in Vinst)
{
sum += lst.Rest.Item2; k++;
richTextBox7.AppendText("Vinst Data" + "\t" + lst.Item1 + "\t" + lst.Item2 + "\t" + lst.Item3 + "\t" + lst.Item4 + "\t" + lst.Item5 + "\t" + lst.Item6 +"\t" + lst.Item7+ "\t" + lst.Rest.Item1 + "\t" + lst.Rest.Item2 + "\n");
foreach (var x in q1)
{
if (k == x.Count)
richTextBox7.AppendText("\nData summa" + " " + sum + "\n");
}
}

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hudikwebb IT8y ago
Hi
Here is the code that I did to solve the problem
var Vinst = new List>
{
Tuple.Create("juli","USD",345.0, 900.0),
Tuple.Create("juli","EUR",200.0, 600.0),
Tuple.Create("juli","SAR",145.0, 300.0),
Tuple.Create("augusti","USD",145.0, 300.0),
};
var lookupResult2 = Vinst.ToLookup(s => s.Item1);
foreach (var group in lookupResult2)
{
// Console.WriteLine("Månad: {0}", group.Key); //Each group has a key
foreach (var s in group)
{ //Each group has a inner collection
Console.WriteLine("Valuta: {0}\n",s.Item2);
Console.WriteLine("Månad: {0} FSK : {1} Vinst{2}\n", s.Item1, s.Item3, s.Item4);
}
Console.WriteLine("Total vinst{0} \t {1}", group.Key , group.Sum(x => x.Item4));
}
Hudikwebb IT8y ago
Hi

The result of your code

Vinst Data juli GBP 6000 13 400 19500 1500 5200 800

Vinst Data juli SAR 1000 2 400 1200 600 800 200

Vinst Data juli USD 4500 8.95 500 15993 1787 4475 25

Vinst Data augusti USD 5700 8.5 600 5950 700 5100 600

Data summa 1625

That is correct if I need to sum up all the last column, but I need ot sum up the data belong to July and placed before August then add the data belong to August.

Like this

Vinst Data juli GBP 6000 13 400 19500 1500 5200 800

Vinst Data juli SAR 1000 2 400 1200 600 800 200

Vinst Data juli USD 4500 8.95 500 15993 1787 4475 25

Data summa 1025

Vinst Data augusti USD 5700 8.5 600 5950 700 5100 600

Data summa 600
Sai Kumar Koona8y ago
Hi,

The inner foreach statement is not needed for the expected output. As you are looping everytime that text is getting added. Also, the if condition in the nested foreach statement is wrong.

Instead of that foreach statement please replace it with following lines of code.
if (k == Vinst.Count) {
richTextBox7.AppendText("\nData summa" + " " + sum + "\n");
}