Improve '% of Total' calculation in Overview
J
Jonathan Wong
When the total expense is a negative value (i.e. if you have a Refunds category), the percentage calculation in the '% of total' column displays values totaling over 100%.
The likely solution is to ignore categories with negative values from counting towards total spending in the calculation.
Currently, the calculation looks like this:
(Expense category) / (All expense categories) x 100
It should look like this instead:
(Expense category) / (Total of only true expense categories) x 100
For an expense category with a negative value (i.e. "Refunds), as it's not included in the calculation, it also shouldn't have a %. It should display a dash (-).
The new calculation would also need to apply to the expenses in the "Period Summary" section.
Log In