Skip to Content
0
Former Member
Nov 29, 2009 at 08:11 PM

how to interpret a formula stored in a transparent table

23 Views

Dear all,

I have filled in a specific transparent table with some formula. I would like to read the table, find the formula and take the result of this formula in a variable

In my table :

Country, formula 1, formula 2

FR, P + 1 ( 1 / 80 ), R * 1 ( 1 - 30 )

In my program,

I read the table with the country as key, and I would like, first to replace the P and R by a value in the program, and I would like to interpret the formula and put the result of this in a variable

if Country = FR

replace P by w_price in formula1

replace R by w_tva in formula2

w_result1 = formula1

w_result2 = formula2

I don't know how to do interpret these 2 statement like :

w_result1 = w_price + 11 ( 1 / 80 )

w_result2 = w_tva * 1 ( 1 - 30 )

I tought to use the field symbol and assign but w/o success for the moment

Can anybody help me ? it is very important.

Thanks

Kind regards

Véronique