postgres sum does not exist code example

Example: postgresql function sum(text) does not exist

make sure the column refered is a number (probably is a text type)