Read Table records one by one

[Former Member]

Hi,

I am getting three records as a table from BW. I want to read each record and do the below calculation dynamically. Can anyone tell me how to do this?

First record-field2 + Second Record-field2 / First record-field2 + Second Record-field2 + Third Record-field2 * 100

Please suggest.

[Former Member · Accepted solution]

Hi,

I think that you can't...

Try to call BW query 3 times and get each time one row, store data in DataStore and perform calculation.

Ola