# Adding Progress Bars to the Savings Budget

**URL:** <https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355>\
**Category:** gSheets Templates\
**Tags:** budgeting, tcs-savings-budget\
**Created:** [January 27, 2021, 4:50am UTC](https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355 "2021-01-27T04:50:09Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![cculber2](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/cculber2/32/4099_2.png) [@cculber2](https://community.tiller.com/u/cculber2)\
**Post date:** [February 3, 2021, 3:08pm UTC](https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355/13 "2021-02-03T15:08:19Z")

</div>

Hey @randy, thanks for the update! I applied the new version and we’re getting close, but it looks like there are still a few tweaks necessary. I noticed that the `Actuals, Expense` formula in `K22` and `Actuals, Income` formula in `K23` weren’t using the Hide filtering logic, so I copied that into those `SUMPRODUCT()` formulas.

After I made that change, a more subtle issue was revealed. It seems that because of the way the above formulas are calculated, categories marked as `Debt` do not get summed properly as their `Period Actuals` in `AI11:AI` will always net out to $0.00. This is creating yet another discrepancy between the sparkline and category rollup values for `Expense Actual`.

Sorry that my contributions seem to always end up pointing out errors. ☹ I really do appreciate everything you’re putting into these optimizations.

---

_[View the full topic](https://community.tiller.com/t/adding-progress-bars-to-the-savings-budget/7355)._