LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dhrobertson

hi all,

this is a difficult one to explain and I hope I can make this simple...

basically my dilemma is this:

I have a whole bunch of records where I need to change a certain value in each record based on a percentage split.
in the below example I have 4 records whereby, based on the numbers to the right I need to assign a town. it doesn't matter which records gets which town, just so long as 1 has Merton, 2 have Wandsworth and 1 has Greenwich. in this example I could get away with giving each record a number 1 - 4 and based on an if statement assign the towns, however, I have a situation whereby I have many different "cities" so this split below only pertains to London. Other cities will have different values. This is maybe a poor example as only London has these towns but say that didn't matter and I wanted to assign these 3 towns to a whole bunch of Cities, each City having a different ratio of towns to apply.

not sure if I have made sense here... if anyone has any idea of how I could go about this... please let me know? to me it has to include grouping, however I need to group and then to logic on those grouped records rather than just get a GroupMax or a groupcount as an example.... any ideas? thanks
Doug

Example:
------------

City town Merton Wandsworth Greenwich

London unspecified 1 2 1
London unspecified 1 2 1
London unspecified 1 2 1
London unspecified 1 2 1

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

I think we're going to need a bit more explanation.
Take a look at the attached graph and see if that helps with what you are wanting.
Attachments:
Assignment.brg