6 Replies Latest reply on Jan 20, 2012 11:28 AM by Sprucegum

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

    MattEsau

      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.