im trying to SUM up some values from a custom record based on certain keys and I couldn't get the saved search sum up properly

have you considered using a utility library like

lodash

to do the summation?