I have two tables:
Table A: This is where the initial amount is stored
Table B: Here are the transactions made each day, where an account can have more than one transaction
Challenge/problem/no idea how to do it
At the end of the day, when you enter the final balance of transactions for each account, update with that dayโs total amount in Table A to find the difference that remains
The question is, how do I do this?
Many thanks for your help!!
@Juan_Gutierrez
Below expression will give you the total end of day transactions for any specified account. Create a Virtual Column in Table A:
SUM(
SELECT(
TableB[End Balance],
[Accounts] = [_THISROW].[Account]
)
)
Great!!!
Iโm going to do it and Iโll be back to comment on the result
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |