To Sum up

[NISHITHA]

Hi Team,

How can we Sum up the Total Amt column for all Division code = 990

So Output should be
Total Value=880(By Sum of 300+290+290)

|Division Code | Country |Text | Total Amt|
|990| INDIA |***IN | 300 |
|990| INDIA |*******YN |290 |
|990 |INDIA |*******CK |290 |
|770 |AFRICA |*******YN |660 |
|880 |BRAZIL |*******KK |440 |

[supermanPunch (Arpan)]

@NISHITHA

|Division Code | Country |Text | Total Amt|
|990| INDIA |***IN | 300 |
|990| INDIA |*******YN |290 |
|990 |INDIA |*******CK |290 |
|770 |AFRICA |*******YN |660 |
|880 |BRAZIL |*******KK |440 |

Hi @NISHITHA ,

Could you maybe try the below :

DT.AsEnumerable.Where(Function(x)x("Division Code").ToString.Equals("990")).Sum(Function(x)CDbl(x("Total Amt").ToString))

[Jithesh_R]

Hii @NISHITHA ,
Please check this workflow.

SUMColumn.zip (2.3 KB)

Regards,

[NISHITHA]

Thanks @supermanPunch for the approach!

[NISHITHA]

Thanks @Jithesh_R for the reference xaml !!!