Report won't SUM column with values

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.
Best Answer
-
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
Answers
-
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?
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!