I’m a bit new to KNIME, so this might be a simple question for the most of you. I am trying to create a single row of data which calculates for me the change in Accounts Receivable (and other working capital line items) on a monthly basis. I am not missing any months, and my data looks like this:
Accounts Receivable Closing Balances per Month
ACCOUNT_NAME | PERIOD_END_DATE | CLOSING |
---|---|---|
Accounts receivable | 1/31/2018 | 100 |
Accounts receivable | 2/28/2018 | 200 |
Accounts receivable | 3/31/2018 | 300 |
Accounts receivable | 4/30/2018 | 355 |
Accounts receivable | 5/31/2018 | 410 |
Accounts receivable | 6/30/2018 | 405 |
Accounts receivable | 7/31/2018 | 460 |
I essentially would like my output to look like this:
ACCOUNT_NAME | PERIOD_END_DATE | CLOSING |
---|---|---|
Accounts receivable | 1/31/2018 | 100 |
Accounts receivable | 2/28/2018 | 100 |
Accounts receivable | 3/31/2018 | 100 |
Accounts receivable | 4/30/2018 | 55 |
Accounts receivable | 5/31/2018 | 55 |
Accounts receivable | 6/30/2018 | -5 |
Accounts receivable | 7/31/2018 | 55 |
As you can see, my requirements are as follows:
- Find the previous month and calculate the closing balance difference from the current month (i.e. Previous minus Current Month)