RECURSIVE CALCULUS

[Pietro_Zaza1]

I have a DB built in the following way:
Item | Date | stock | purchase orders | forecast

I would like to obtain a column calculate in the following way:
stock of the previous period+Purchase orders-forecast
in order to get a stock projection over time.
the formula should be the following:

[mwiegand]

Hi @Pietro_Zaza1,

welcome to the community. As far as I could comprehend, please correct if the following statement is wrong, all data in the same row. If so, f Math Formula Node should do the trick:

Math Formula

If not, can you share the data or a sample of it please?

Best
Mike

[izaychik63]

Please see example

RunningTotal — NodePit

and node

Moving Aggregator — NodePit

[gonhaddock]

Hello @Pietro_Zaza1
I guess that you are working on different products as well. You can take a look into the following post. This may be useful for your use case:

Using data from previous row in calculation with loop

Hello @Aura02 , and welcome to the KNIME community. I’ve deployed an alternative solution for your use. This alternative solution is also supported with ‘Column Expressions’ node; however it deals with the problem with very simple math, using by ranges the full cumulative column for each of the variables scoped in the equation. Then no loop is needed, improving in performance. As @takbb commented, it wasn’t clear for me either the excel formulas coming from the image… then I decided to simplif…

As @mwiegand commented, can you provide a mock sample data + expected results?

BR