That is because your Weight1 and Weight fields have one to many relationship with Overall Prespective.
So to solve the problem you can either average Weight1 and group by Overall Prespective in the script. Or use the following expression.
Level 2 =((Column(2)/Column(1)*100)* Avg(Weight1))
Level 1 = (Column(2)/Column(1)*100)* Avg (Weight1)* avg (Weight)
However this is based on the assumption that Weight and Weight1 can be averaged.