Hi,
Hope you all doing well… I have an excel file in that one of the NAME - “Rishi” was added two times so we have to calculate the sum of Prices for rishi (total - 50)
Bot has download the another excel after 1hour in that Excel it has some random equal names and we have calculate the sum…!!
Thanks,
Rishi
ppr
(Peter Preuss)
November 12, 2021, 11:23am
2
we can group the data on the name and suming up the resulting group individually.
For implementation options have a look here:
This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data.
Introduction
Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items.
Lets have a look on following data:
[grafik]
A possible scenario could be:
Create a report containing following information:
the region code
the sum of CaseCount per RegionCode
t…
Hi
Have a View on this thread with a expression to group and sum a column
I have a datatable as below. I want to group by using Col3 and take sum of Col2.
Input Datatable:
Col1 – Col2 – Col3 – Col4
A – 11 – AA – XYZ
B – 12 – RT – XYZ
C – 13 – HL – XYZ
D – 27 – AA – XYZ
E – 17 – AA – XYZ
F – 15 – RT – XYZ
G – 24 – HL – XYZ
OutPut required:
Col1 – Col2
AA – 55
RT – 27
HL – 37
Please help me with the LINQ query.
@ppr @arivu96 @ClaytonM
Cheers @Rishik_Chowdary
system
(system)
Closed
November 15, 2021, 11:26am
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.