02-28-2017 1:12 PM
Hi Experts,
I have a requirement in which there is a custom formulas table maintained.
The table entries looks something like this.
ID Formula
LL1 speed * time
LL2 speed / time
etc...
Now in my report i will be fetching speed, time and the "id" that i have to use.
How to dynamically use the formulas section of the above table table and get my results.
For eg:
In my report speed = 100
time = 5.
If table entry is speed * time.
then my result should be 500.
Later if someone changes the table entry to speed / time.
then my result of the program should be 100 / 5 = 20.
Can you please provide the logic on how to handle this dynamically in my code.
Please let me know if you need any further info on this.
02-28-2017 1:59 PM
A small search results in FM EVAL_FORMULA ...
02-28-2017 1:59 PM
A small search results in FM EVAL_FORMULA ...
02-28-2017 3:27 PM
02-28-2017 5:58 PM
That was = search = speed * efficient - time taken for example - time wasted waiting for reply + Richard Harper chuckling.
03-01-2017 5:49 AM
Thanks a lot Keller the FM EVAL_FORMULA was very helpful for my requirement.