Hey everyone,

I’ve been trying to duplicate an excel formula in Knime but I don’t know how.

Here’s my problem:

My input table is similar to this one

Month | Quantity | Data | Calculated quantity |
---|---|---|---|

1 | A | X | A+X |

2 | A+X | Y | A+X+Y |

3 | A+X+Y | Z | A+X+Y+Z |

The calculated quantity changes depending on the month. It always adds the last month quantity.

How can I have the same result in Knime?

Thank you