Hi,
I recently came acrross a formula to group by a sum value ;
Table.Group custom comparer ;
I sort of get that in custom group (x,y)=> each time a true is returned a new group is started so ;
Please Login or Register to view this content.
But I recently found this formula and can't figure it out;
so this will mean that the sum of units for each group < 50 , but I can't figure how the count for lList.Range , is workingPlease Login or Register to view this content.
so index x and y x = current y = next ?
so 2 - 1 + 1 = 2, 3 - 2 + 1 = 2 , 4 - 3 + 1 = 2, but if 2 is used the formula breaks so this cannot be what is happening ? All I can guess is that
the y value increases / iterates through until the condition is met, 2 - 1 +1 , 3 - 1 + 1, 4 -1 + 1 etc. ?
if anyone can help in explaining how this is working please do , I have read ( i think most of )
PQ how on this but it did not really help this, unless i missed that bit.
I have attached a work book with examples.
Richard.
Bookmarks