I have data that are Bank Account Balances. My data source is a table with date, transaction description, amount of transaction, and balance after that transaction. If there were no transaction during a a certain days, there will be no data for that day.
Also, there might be multiple transactions in a day, therefore, multiple balances assigned to that date.
I have this structure for multiple banks and I have a field with Bank Account Names.
I want to create a summary table with Bank Account (which I have), date, and balance of that account at the end of that date.
I have two problems that seem to be related:
Here are the solutions I tried but did not get very far:
I tried using Previous_Value function but when there was a day with a new balance I kept getting the balance of the first day.
Let me know if there is more info you need.
If anybody can help me, I would appreciate it.
1. To show previous Balance when the day have no transaction, how about this?
2. If there are no field that show which record is the last in certain day I think it is difficult.
I hope anyone please ideas.