4 Replies Latest reply on Jan 11, 2017 7:45 AM by Udit Mahajan

# Split Records into three equal parts amongst 3 personID

In the above snapshot, I want to divide 154 records in florida into 3 equal parts or approximate equal parts amongs person A, B and C. Similarly I want to do it for the remaining states.

Regards,

Udit

• ###### 1. Re: Split Records into three equal parts amongst 3 personID

Hi,

I haven't tested this, but try something like

IF INDEX([state]) < COUNTD([state)]/3 THEN "P1"

ELSEIF INDEX([state]) > COUNTD([state])*2/3 THEN "P3"

ELSE "P2"

END

Hope this helps!

Kind regards,

Wim

• ###### 2. Re: Split Records into three equal parts amongst 3 personID

It gives above error.

Regards,

Udit

• ###### 3. Re: Split Records into three equal parts amongst 3 personID

Woops, seems like I not only used the wrong function, but also misread your initial question.  Sorry about that.

Please disregard my previous post.

What field did you use to calculate the numbers next to your States?

• ###### 4. Re: Split Records into three equal parts amongst 3 personID

It is Sum(Number of Records)