AnsweredAssumed Answered

Using a field value to set the operator in a calculation. Stuck!

Question asked by MattEsau on Jan 20, 2012
Latest reply on Jan 20, 2012 by Sprucegum

Title

Using a field value to set the operator in a calculation. Stuck!

Post

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?

Thanks, Matt.

Outcomes