Need to split data based on 30% of total then 70% of total.

[peyton-louden]

Hello, I am trying to create a flow that separates some amounts and assign them to two groups based on the percent of the total. One group needs to be 30% of the total amount and assigned group number "1" then group "2" needs to be the other 70%. 

I've been stumped on trying to fix for some time would appreciate some help. 

Also, I have uploaded some sample data for reference. 

Thanks. 

[Luke_C · Accepted solution]

Hi @peyton-louden 

Here's how I'd approach this:

1. Summarize tool to get total
2. Append total back to each record
3. Compute % of total for each record
4. Running total to sum the %s
5. Formula to check if the running total is <30% and assign the group.

You can apply whatever sorting you'd like before this process (i.e. values low to high) and it should still work.

[peyton-louden]

This works great! Thanks!