combine where and eval

[pduvofmr]

Hi Community,

how do i combine where and eval?
Available field are "Gear" and "Torque_Crankshaft"

Discribed in my human brain / language 😉

eval "Torque_Wheel" = (where ("Gear"=1 == ("Torque_Crankshaft"*5.0000)), ("Gear"=2 == ("Torque_Crankshaft"*3.2000")), ("Gear"=3 == ("Torque_Crankshaft"*2.1429)))

[ITWhisperer · Accepted solution]

Have you looked at the case function?

[pduvofmr]

Hi,

case works fine for me... thx