Evaluate a stored formula in script

[#1]

Hello,

I've 2 tables that are stored in QVD's

• definition table: the id's, for what I must calculate the formula written in the field "formula"
• values tables: the values needed to calculate the formula

I would like to create a script and get the calculations with help of the values tables directly in script. That means that I must find a way to evaluate the Formula. Does anybody have an idea on how to do that ? Do I think in the false direction ?

As a result, I simply would like that:

• DepID_1008 --> 40 - 66 = -26
• DepID_1009 --> 40 - 66 + 55 = 29

Thanks,

Ivan

[Jason_Michaelides]

FI4030 - FI4027 = -26, not 5 so how do you get your desired results?

[#3 · Accepted solution]

Okay,

I've found, I can do that in script with the evaluate() function.

Regards,

Ivan