How to calculate formula from text variable.

Hello All NAV Developers,

We have a requirement where the user will put a string on each Item card and system should calculate the formula by replacing the actual value.

On Item1

Filed Name VALUE

FORMULA ELEMENT “(LxWxD)^2”

based on the actual values of L, W and D system should replace then and calculate the formula and assign it in a variable.

The above mentioned formulas will be different item to item so we need to have generic code to cater all the options.

Any suggestion on this will be highly appreciated.

Regards,

Hi,

http://mibuso.com/dlinfo.asp?FileID=820

http://gotcal.com/index.php/2010/06/evaluate-formulas-in-dynamics-nav-2/