How to get the value of stored mathematic formula
selece28
Member Posts: 316
Hi Nav masters,
My client want me to create a table that contain mathematic formula for their calculation. The idea is to store an mathematic formula ex: (A+B)*(A+C)
then store A,B,C in a different table as parameters.
I managed to create both table and insert the value of A,B,C into my formula
Ex: A=1, B=2, C=3
I managed to get String of (1+2)*(1+3)
My question is, how to get the value, because it is a string and i cant convert it into decimal
](*,) ](*,) ](*,)
Is there any other idea to store formula in table.
This is so that user can create many formula and the parameters is dynamic.
Thanks in advance
My client want me to create a table that contain mathematic formula for their calculation. The idea is to store an mathematic formula ex: (A+B)*(A+C)
then store A,B,C in a different table as parameters.
I managed to create both table and insert the value of A,B,C into my formula
Ex: A=1, B=2, C=3
I managed to get String of (1+2)*(1+3)
My question is, how to get the value, because it is a string and i cant convert it into decimal
](*,) ](*,) ](*,)
Is there any other idea to store formula in table.
This is so that user can create many formula and the parameters is dynamic.
Thanks in advance
______________
Regards,
Steven
Regards,
Steven
0
Answers
-
Use the EVALUATE function to convert the String to numbersNAV - Norton Anti Virus
ERP Consultant (not just Navision) & Navision challenger0 -
-
Thanks, Its solved______________
Regards,
Steven0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 328 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions