@Sam-I-Am I don't know if this is related to your issue but sometimes when

SUM()

doesn't work as expected there is a workaround to use

SUM /*comment*/( )

.