Is your calculated field formatted for text or number? If it was formatted for number, then if you bring it in as a column, there should be an option to aggregate by SUM, no text mode needed. It's in the Column Settings area, under "summarize this column by:"
If the calculated field is formatted a...