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

solarissfAsked:
Who is Participating?
 
Fernando SotoConnect With a Mentor RetiredCommented:
This should also work if you wish to go that route.

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

Open in new window

0
 
Fernando SotoRetiredCommented:
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

0
 
solarissfAuthor Commented:
that's the catch... I don't want to group by anything... I just want to sum up some properties without grouping
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
solarissfAuthor Commented:
something like this..
but does not work

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

Open in new window

0
 
Fernando SotoRetiredCommented:
Please see my post and how I implemented the code.
0
 
Fernando SotoRetiredCommented:
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.
0
 
solarissfAuthor Commented:
yepp... I just figured it out and it was the same as your last post... thanks!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.