I am working on something similar, but haven't quite gotten it worked out. Have you tried something like using aggregation "Highest", "Median", and "Lowest" with the corresponding weights?
Gradebook
Individual Variable Weights
This discussion has been locked so you can no longer reply to it.