This is what I found!

In Madrid the value being summarized is actual_value. Since "The actual value is equal to the Value of the metric definition associated with the chosen answer option",the script does not return weighted score but just a score //sum of values of all answers.

Checking in New York the script includes (ChangeRiskAsmt)  has been updated and it summarizes the normalized_value. It seems this is more correct as normalized_value will actually return the value*weight. However, I observed that the normalized value will be set with negative value on the first response of a category. I couldn't figure out why or how the value is being calculated.

I did found out though that there is a third filed, which is not shown in the form. It is called weighted_value it works exactly as expected. I have no idea why it is not used in the script.

So all I had to do, was to change the actual_value, in Madrid and normalized_value, in New York with weighted_value and now the Script returns the weighted score. 

I`m yet to find how to use the categories weight but this is another topic.

BTW the fields mentioned above are in asmt_metric_result table.