This may be a little hard to describe

[#1]

I have four columns - A current allocation percentage, proposed allocation percentage, and a weight for specific types of classes.  Note the last class should be a subtraction of whatever is left over from 100.  So for example:

CLASS  ALLOCATION  PROPOSED  WEIGHT

C1                A                      =A*W              W

C2                A2                    =A*W2            W

C3                A3                    Whatever's Left Over out of 100

C1               25                      3.75                 .15

C2               40                      18                    .45

C3               35                      78.25              N/A

I'm having trouble with the calculation of the underlined column.  Any ideas?

[Clever_Anjos]

Not sure about your exact requirement, please find attached a possible solution

[sinanozdemir]

Hi Kevin,

I cannot open cleveranjos solutions since I only have the personal edition, but here is my approach which is not so elegant:

I also put weights into variables.

Again, this is based on the data you provided. If there are more classes, then the script needs to be adjusted accordingly. I am also attaching my qvw.

Hope this helps.