Loading

sum values in datatable using linq based on conditions

sum values in datatable using linq based on conditions

Vignesh Kumar

11y1.3kLINQ

Hi,

I'm having a datatable like mentioned below.

ID Percentage

1 50

1 30

2 0

2 100

Result:

ID Percentage

1 80

2 100

Now I need to sum the percentage for each ID and the percentage for each ID should be 0 or 100 percentage.

If any one of the ID in table doesn't have 0 or 100 I need to alert. Pls suggest me how I can do this in linq and I think its the best way.

2 Replies

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

Lawrence P11y ago
public class holder
{
public int ID { get; set; }
public int Percentage { get; set; }
}
void Main()
{
List myHolderList = new List(){
new holder(){ ID=1, Percentage=50},
new holder() { ID=1, Percentage=30},
new holder() {ID=2, Percentage =0},
new holder(){ID=2, Percentage =100}};

var result = myHolderList
.GroupBy (hl =>new {myID =hl.ID })
.Select (hl =>new {hl.Key.myID, Total =hl.Sum(h=>h.Percentage) }).ToList();
}

// Define other methods and classes here

List
myID Total
1 80
2 100
Guest User11y ago
Here's an example:

class Custom
{
public int Id { get; set; }
public int Percentage { get; set; }
}

void Main()
{
List data = new List()
{
new Custom() { Id = 1, Percentage = 50 },
new Custom() { Id = 1, Percentage = 30 },
new Custom() { Id = 2, Percentage = 0 },
new Custom() { Id = 2, Percentage = 100 }
};

IEnumerable summedData = data.GroupBy(item => item.Id).Select(grp => new Custom() { Id = grp.Key, Percentage = grp.Sum(item => item.Percentage) });
foreach (Custom item in summedData)
{
Debug.WriteLine(string.Format("ID: {0}, Percentage: {1}", item.Id, item.Percentage));
}
Debug.WriteLine("");
IEnumerable alertData = summedData.Where(item => item.Percentage > 0 && item.Percentage < 100);
foreach (Custom item in alertData)
{
Debug.WriteLine(string.Format("ID: {0}, Percentage: {1}", item.Id, item.Percentage));
}
}