I don’t think Filemaker allows values to be stored as ‘operators’, and so any value entered in Landed Modifier Operator is probably being stored as ‘text’. Because there are a limited number of possible operators, you might try something like:
d = (Cost/Exchange rate) * (1+(Duty_new/100));
o = Landed Modifier Operator;
m = Landed Modifier];
Case(o = "/"; d / m; o = "*"; d * m; o = "+"; d + m; o = "-"; d - m; d)
Perfect, works a treat! Although strangely FM doesn't seem to like the '-' in the value list and won't let it be selected. However that's no big deal as I can use the '+' operator and a negative numeric value to achieve the same thing. I did try using Case, but this way makes more sense. Easy when you know how!
"FM doesn't seem to like the '-' in the value list and won't let it be selected"
You're right. FM allows values in a value list to be separated using "-", (and so the separator cannot be selected as a value). You could use underscore "_".
Yes, that's a thought. Thanks.
Actually, you can store operators in fields and then have a calculation use that operator to compute a value:
Use the evaluate function for that.
Evaluate ( (Cost/Exchange rate) * (1+(Duty_new/100)) & Landed Modifier Operator & Landed Modifier )
Very nice use of EVALUATE function. Thanks very much for your invaluable contribution to this forum!