In the front end a user inputs how to configure the sell price of the part "AmtCost * 1.18". This is contained in a text field. How do I extract that out of the text to use in a select statement?
AmtCost is a field name. The user could use AmtPrice1(another Field name) or AmtCost2 or about 5 other cost fields.
So the users specifies which field he wants to use in the calculation then the (* or / or +) and then specifies the factor such as 1.18.
Not sure how to explain, I hope this make sense.