Hi everybody, I’ve found some different posts on this topic already but unfortunately none of them helped me with my problem and maybe some of you pros can help me :). I want to basically create the Excel Goal Seek function inside KNIME by maximizing the Revenue column and hitting 90% in the Percentage column by changing the amount of pieces sold (between the from and to values) for each row. Is something like this possible? Here are some sample data a excel file: Example.xlsx (11.3 KB) Best regards and thank you in advance! Timo

I think a simpler way to go is to use a Parameter Optimization loop: [image] [image] Goal Seek – elsamuel Solutions for data science: find workflows, nodes and components, and collaborate in spaces.

Excel Goal Seek function in KNIME

KNIME Analytics Platform

elsamuel April 8, 2021, 4:45pm 5

I think a simpler way to go is to use a Parameter Optimization loop:

4 Likes

Perform "Goal Seek" function in Knime