Using a field value to set the operator in a calculation. Stuck!
Hi, I feel like this is going to be a stupid question to ask because it seems like it should be such a simple thing to do, but I admit, I am totally stuck! Here is the numeric calculation I am working on..
((Cost/Exchange rate) * (1+(Duty_new/100))) Landed Modifier Operator Landed Modifier
At the end of the caluclation are two seperate fields 'Landed Modifier Operator' and 'Landed Modifier'. The idea is that the user pics an operator /,*,-,+ and this is the field value for 'Landed Modifier Operator'. They then enter any numeric value 'Landed Modifier' to apply, via the chosen operator, to the initial part of the calculation. The thing is FM wants to see operators between the initial calculation and the two fields, but I want 'Landed Modifier Operator' to be this operator and I cannot see how that's done?
Can anyone help?