Multi-Row Formula

[Sarath27]

Hi All,

I am trying to form of Group ID based on similar records of a field below ECM_Party_ID. Just because it has "Nulls" in between it is forming a new group ID. I want my result to be in below format.

I have attached the formula, pls help me achieve the below output. Thanks in Advance.

Record_ID	ECM_PARTY_ID	New_Group_ID	Columnn C should be
1	9681214	7	7
1	9681214	7	7
1		8	7
1	9681214	9	7
1	9681214	9	7
1	9681214	9	7
1		10	7
1	9681214	11	7
1	9681214	11	7
1	9681214	11	7
1	9681214	11	7
1		12	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
1	9681214	13	7
2	9830113	14	8
2	9830113	14	8
3	6257890	15	9
3	6257890	15	9
4	9799713	16	10
4	9799713	16	10
4		17	10
4	9799713	17	10

[IraWatt]

Hey @Sarath27,

Here is one way to get round this. You can filter off the NULL rows and re-join after the formula and finally sort to get the initial ordering:

Not sure why your New_Group_ID starts at 7?

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[DataNath]

Would something like this not work? Basically use an initial Multi-Row Formula to fill in the blanks and then assign the progressive ID, before removing the temporary 'filler' field to arrive at the desired format:

[binuacs]

@Sarath27 One way of doing this