math formula

[Gabriel2020]

Good morning people, everything fine ?

I have a challenge, and I urgently need your help. I’ll try to explain and leave the workflow below so you can help me.

I have the calculated median based on Originxdestinoxvehicle, but for that same originxdestination I have 4 more types of vehicles, where I should understand for example.

If it is a truck, it needs to divide the median value by 16, which is the number of pallets that fit in the truck, and the result of this division must be multiplied for the other types of vehicle, for example, a truck, which would be 28.

CART 28
MEDIUM - 3/4 8
STUMP 12
TRUCK 16
VUC 4

KNIME_project7.knwf (195.4 KB)

[denisfi]

Hi, let me see it… first, can we group by the information just by “Veiculo realizado” and make a calc for median, ignoring others columns? if so, a group by node can make this calc for you and result a simple answer.

The result is:

After that, you can create the rules and make some calcs:

KNIME_project7_gabriel2020.knwf (289.8 KB)

See if the wf helps you.

Tks,

Denis