Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Not sure about your exact requirement, please find attached a possible solution
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.