Creating history of stock balace
Hope you are doing well.
I have been trying to recreate a history of stock balance, but so far, even consulting some people with good experience in rapidminer, I haven’t been able to do what I need. Maybe you guys would be able to help me.
Below is one example set. Basically, I have initial stock on 02/04. Based on despatches and receipts of the previous days I need to calculate the initial stock for 01/04 and 31/03… all the processes I have tried would work with one product code only, but when the date changes to the next product code it gives incorrect values.
|Code||Initial Stock on 02/04||Trx Data||Trx Time||Trx Type||Adjust|
Below is what I expect to get.
thank you all in advance.