I have a problem i am wondering if it can be solved: a client wants to see a table where he accumulates only the positive delta's: he has the following schema:
The balances are the current balances on the end of the month, accumulated across multiple clients. The data-set contains the balances per day per client. We want to calculate the positive and negative delta's:
only show the amount that has increased and the amount that has decreased.