I have 2 tables, table A contains daily quantities and table B has 1 row for each month with a beginning balance.
When I join these 2 on month, each row of table A is listed and the balance from table B is shown on each row. I can perform math with extra fields, but I somehow need to process the beginning balance for only 1 row
I would like to add the beginning balance to the sum of all of table A quantities and not add it on each row.
