Report won't SUM column with values

mtk5200

Capture2.PNG

Capture.PNG

I've attached a screenshot of my report of our budget. The column called Budgeted I originally had named Budgeted 2024. When I renamed it to just Budgeted, I deleted off the Budgeted 2024 column, refreshed, and added the new Budgeted column. I now can't get it to sum.

Matt Johnson

Hi @mtk5200

I would try rebuilding the report from scratch. Don't do a save as new, but try a totally new report. Sometimes that does the trick.

I hope that helps.

Matt

mtk5200

Okay, I now saved it as a new report and it is summing but won't put it in Currency format. The column is only coming from one sheet and the entire column is formatted to Currency. Any ideas?

Capture3.PNG

Matt Johnson

Hi @mtk5200

I would try rebuilding the report from scratch. Don't do a save as new, but try a totally new report. Sometimes that does the trick.

I hope that helps.

Matt