Calculating a formula, that is in a string using bls

[Former Member]

We are attempting to bring in formulas into our bls from our SQL database and have them calculate. We have tried to bring them in as transactional properties into our expression editor but he problem is the expression editor see's the formula as a string and does not calculate it. Does anyone know how to take a formula that is in a string and have it calculate in a bls?

We are using MII 12.0

Thanks,

George

Edited by: George Matos on Aug 11, 2009 11:35 PM

Edited by: George Matos on Aug 11, 2009 11:37 PM

[Former Member · Accepted solution]

George Matos,

Assume you have a table with a field FormulaExpression. which contains a string *"5 + (12 * 2) - 11"*.

Now to show this field as evaluation of the formula (that is 18) you need to use create a query to return this field. Later use this query in a transaction & assign dynamic link of this field to the target variable:

That is: Transaction.OutputValue field should get value from the dynamic link of this field.

#SQL_Query_0.Results{/Rowsets/Rowset/Row/FormulaExpression}#

BR,

SB

[Former Member · Accepted solution]

It works great. Thanks.

George