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,

Look at the following Link

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

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

This might help you

Thanks Mr. Amol,

For your prompt reply with the solution, it was a great help me.

Thanks for your time and efforts, really appreciated.

Regards,

Welcome…