Hi, i have a question is possible if i have a columns of task name, start date, finish date and cost of the task create a cash flow adding columns of control monthly
Can you maybe explain the logic that is applied in getting from first screenshot to the second one?
I’m a big fan of using KNIME in finance - this seems to go in the direction of what I call a financial model pipeline - maybe this article I wrote can help you progress as well:
Happy to advise if you can elaborate a little bit more on the exact logic in your case…
2 Likes
the logic is that the check week date or check monthly date columns in the second screenshot calculate how much of this task has spended (not accumulated) in base to the information of start to finish and the cost of the task of the first screenshot
Hey,
sorry for taking a while to reply.
Have to admit not 100% clear on your requirement, but based on what I saw and in the absence of example data, I put together this minimal example:
Workflow:
cashflow.knwf (91.6 KB)
5 Likes
Thanks you very much, is exactly that i want