topic Re: formula parser in Application Development and Automation Discussions

formula parser

Former Member — Wed, 11 Jul 2007 08:36:22 GMT

Dear all,

does ABAP provide something like a formula parser to calculate for example:

2*(A+B)/(C-D) correctly?

Best regards,

Christoph Aschauer

Re: formula parser

jaideeps — Wed, 11 Jul 2007 08:46:40 GMT

hi,

When you combine arithmetic expressions, ABAP performs the calculation from left to right, with one exception: Powers are calculates from right to left. So <n> ** <m> ** <p> is the same as <n> ** ( <m> ** <p> ), not ( <n> ** <m> ) ** <p>.

DATA: pack TYPE p DECIMALS 0.

pack = 1 / 3 * 3.

WRITE pack.

ans: 1

i think it follows BODMAS rule

thanks

jaideep

*reward points if useful

Re: formula parser

Former Member — Wed, 11 Jul 2007 09:00:59 GMT

Sorry guys,

I did not post the issue clearly.

I get a formula as a string: 2*(A + B)/(C+D).

the values of A ... D are stored somewhere.

I like to have the possibility to calculate the value dynamically, but like to avoid "GENERATE SUBROUTINE POOL.

Christoph Aschauer

Re: formula parser

Former Member — Mon, 16 Jul 2007 07:41:11 GMT

Hi all,

I solved the problems as follows:

- limitation of 36 subroutines: SUBMIT program. (this program generates the generic subroutine pools (communication via DB or shared objects possible)

- limitation of subroutine pool line ( 255 chars ).

also this is an executable calculation:

calc =

(

)

So no longer line restriction when having a very long formula string to be generically processed.

Christoph

Re: formula parser

Former Member — Mon, 16 Jul 2007 07:44:48 GMT

solved the problem on my own. Please see the comment above or feel free to ask.

Christoph