topic Re: Dynamic Formula Selection in Application Development and Automation Discussions

Dynamic Formula Selection

Former Member — Mon, 25 Jul 2016 06:05:10 GMT

Hi Team,

I have a database table with formula as shown below(this table contains around 100 formulaes).My Input parameters to the program are Length,breadth and width and design.Based on the these input values how to do the caliculation dynamically. Please suggest solution.

Design Formulae

Box	L+B
Rect	L*B
Square	W*B

Thanks and Regards,

Uma

Re: Dynamic Formula Selection

Former Member — Mon, 25 Jul 2016 06:37:23 GMT

Dear Uma,

Please try the below link :

Program to evaluate formula in a string - ABAP Development - SCN Wiki

I think that it can help for your case.

Regards,

Yance

Re: Dynamic Formula Selection

SimoneMilesi — Mon, 25 Jul 2016 06:38:26 GMT

Hi Uma,

you can read your table with your input "design" and associate L, B, W to input parameters.

Finally you can check this tech to do the calculations

Program to evaluate formula in a string - ABAP Development - SCN Wiki

Exactly as Yance also said

Re: Dynamic Formula Selection

Former Member — Thu, 11 Aug 2016 09:23:49 GMT

Hi team,

The above metioned link is not working this kind of cases when if there are numeric values present in the formulae. Can any one suggest solution how to calicultate this kind of formulae.

Material area =(W+D)x(2L+2W+2)

Material area =(W+D+2)x(2L+2W+2)

Material area =(0.5W+D)x(2L+2W+2)

Material area =(2W+D)x(2L+2W+2)

Material area = (L+D)x(2L+2W+2)

Re: Dynamic Formula Selection

Sandra_Rossi — Thu, 11 Aug 2016 10:39:34 GMT

Not exactly: numbers are accepted, but not in front of variables without the '*' operator, i.e. it won't work for 2L, 0.5W and 2W. You should write it 2*L, 0.5*W and 2*W. You need to execute a transformation of the formula using regular expression for instance, before using the EVAL_FORMULA function module.

Re: Dynamic Formula Selection

Former Member — Thu, 11 Aug 2016 11:46:44 GMT

Hi Sandra,

Thanks for your input.When I am using this function Module in Webdynpro method I am getting error because of form and end form.Could you please suggest any other way to use in webdynpro.

Thanks and Regards,

Uma

Re: Dynamic Formula Selection

Sandra_Rossi — Thu, 11 Aug 2016 14:30:29 GMT

Here, the issue is not about formula, it's just a simple ABAP problem. You cannot have a form in a class pool, so just define the callback form in a report or function group!