How to find the max after I found a total of the amount

Roelof

Hello,

I have this method :

public void MaxMoneySoldInaHour(List transactions)
        {
            var answer = transactions.
                GroupBy(i => i.TimeWhenSold.Hour).
                Select(group => new { Hour = group.Key, Count = group.Sum(i => i.TotalPrice)}).
                ToList();


            //TransactionCVSParser.WriteOutComeMoney(answer);
        }
    }

but I try to find the max of the sum calculated by the select.

How can I make that work ?

Roelof

3 Replies

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

Roelof6y ago
To be clear. I want to display the hour and the amount
0
Piyush Pansuriya6y ago
Hi,
Please try below code
public void MaxMoneySoldInaHour(List transactions)
        {
            var answer = transactions.
                GroupBy(i => i.TimeWhenSold.Hour).
                Select(group => new { Hour = group.Key, Count = group.Sum(i => i.TotalPrice)}).
                ToList();
               var maxCount= answer.Max(a => a.Count);

            //TransactionCVSParser.WriteOutComeMoney(answer);
        }
    }
maxCount will retrun the meximum number of count.
0
Jignesh Kumar6y ago
Hi,

Please find below link and check Max with Group By.
https://www.csharp-examples.net/linq-max/
0