sum property of observable collection

Hi guys,

I am trying to sum a property in my observable collection.

Tried below using LINQ and not working, any idea what I'm doing wrong?

                var summationResult =
                        from p in BreakdownClass
                        select into g
                        {
                            previousPos = g.Sum(p => p.tPrevPos),
                            previousPL = g.Sum(p => p.tPrevPL),
                            topPos = g.Sum(p => p.tTopTrd),
                            topPL = g.Sum(p => p.tTopPL),
                            netPos = g.Sum(p => p.tNetPos),
                            netPL = g.Sum(p => p.tNetPL)
                        };

Open in new window

C#.NET ProgrammingLINQ Query

Last Comment

Stephen Forero

8/22/2022 - Mon

Fernando Soto

1/10/2014

Hi solarissf;

Give it a try like this.

var summationResult =
    from p in BreakdownClass 
    group p by "OneGroup" into g
    select new
    {
        previousPos = g.Sum(p => p.tPrevPos),
        previousPL = g.Sum(p => p.tPrevPL),
        topPos = g.Sum(p => p.tTopTrd),
        topPL = g.Sum(p => p.tTopPL),
        netPos = g.Sum(p => p.tNetPos),
        netPL = g.Sum(p => p.tNetPL)
    };

Open in new window

Stephen Forero

1/10/2014

ASKER

that's the catch... I don't want to group by anything... I just want to sum up some properties without grouping

Stephen Forero

1/10/2014

ASKER

something like this..
but does not work

                var summationResult =
                    
                    BreakdownClass.Sum(x => x.tPrevPL),
                    BreakdownClass.Sum(x => x.tPrevPos),
                    ;

Open in new window

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

Fernando Soto

1/10/2014

Please see my post and how I implemented the code.

Fernando Soto

1/10/2014

Each iteration of the query returns one record so either you group in the query or you iterate through all returned records and sum them up.

ASKER CERTIFIED SOLUTION

Fernando Soto

1/10/2014