Anyone know why this query bombs? "SELECT custrecord_xyz, SUM(NVL(custrecord_decimalnum, 0)) FROM customrecord_customrecordabc"? Specifically in regards to the SUM function. Field it's pulling is a decimal number.

You either need to remove the first field you're selecting from or add it to a group by

SELECT
    SUM(NVL(custrecord_decimalnum, 0))
FROM
    customrecord_customrecordabc


SELECT
    custrecord_xyz,
    SUM(NVL(custrecord_decimalnum, 0))
FROM
    customrecord_customrecordabc
GROUP BY
    custrecord_xyz

Ahh, thanks! It's definitely Monday.