There was an underlying issue in the dataset i was summing on, unfortunately i don't remember the specific details, but i think it was something with hidden decimals. I did get it to work in the end.