Filtering one collection with 2 columns

[bonifacy]

Hi,

I have one collection which looks like this (it is an example):

Line---Split
1-------25
1-------25
1-------25
1-------25
2-------50
2-------49
3-------1

The main validation rule for this is "Split must equal 100 across particular Line".
So if 4 lines with Line "1" exist the sum of the 4 splits must be 100 percent.

Above you can see that Line "1" will be OK but Line "2" and Line "3" will not. (sum of Splits in Line 1 = 100 but in Line 2= 99 and in Line 3 = 1)

I must check which Line is valid. In the above example, the output should be "1 - True, 2 - False, 3 - False" (or something like that).
Can you give me some tips how to start with this case?

 

[Wilson]

Hi bonifacy

You can try to use Untility - Collection Manipulation /filter collection, filter Column "Line", and sum it, and you'll get what you want when you go through the collection.