the rule on how 3.6 is derived is not clear. May we ask you to resharp the requirements and their definitions
Sorry, it’s 2.6
Just addition of columns that are different.
still the same, the rules are not closed is any 0 blocking the group sums …?
Please start with complete case description. Thanks
looks like a group by on column c1
then the group members will be sum up the col values when the col values are different
checking if the group member col val is different:
grp.Select(Function (x) x(ColNameOrIndex).toString.Trim).Distinct().Count = 1
I’m unable to put them together.
Can you provide the expression for this example.
we can set it up within a hybrid approach balancing LINQ and essential actvities:
- Grouping the data
- Processing the groups
- loping dedicated cols from the group member
- checking if we do have same values or we will sum up
Find starter help here:
GroupyBy_1Col_SumColsWhenDifferent.xaml (14.1 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.