Here how it's supposed to work -
In APRIL, you add an expense, for toilet paper, at 100$
It's still April, you change it, you view your report for April, it shows up as 100$
If you view March, for the FIRST TIME, it will save 100$, since that's the price when you're viewing it.
Now it MAY. You haven't viewed the April report yet in May, because it's the end of April, and you're adjusting your expense. So you change the toilet paper cost to 50$, since you're forcing your passengers to use pinecones, so you add another expense for pinecones, at $25.
Now, you go and view APRIL. It will save the current expenses you have
So March:
TP - 50$
April:
TP: 50$
Pinecones: 25$
May:
TP: 50$
Pinecones: 25$
Now June rolls around, you adjust again, so, TP for 100$, pinecones are 10$, and you view MAY to save May's expenses:
So March:
TP - 50$
April:
TP: 50$
Pinecones: 25$
May:
TP: 100$
Pinecones: 10$
Etc, etc, so-on and so forth. It's funky because PHP isn't perpetual, I can't keep a running tally unless I make some other changes which I'm contemplating on making.
So it seems like there's a bug with it picking up the expense per month. I'll check that out, since the financedata table looks like it's saving the correct data.
Thanks