Skip to Content
0
May 07, 2018 at 02:43 AM

How can you set up BEx Query with special Calculation refering Colum in the row above and below

148 Views Last edit May 07, 2018 at 04:13 PM 6 rev

Hello Expert, I have a requirement where I need to set up a special Query. I wonder if anyone have worked in such requirement. I need to create a column with some X value calculation where I need to refer to different row and Column has show below

ColumnA = 100 ColumnB = 200 ColumnC = 300 in row 1 I need BEX to calculated X1 in row 2 and X2 in row 3 according to the formula below and considering row 1

in raw 2 and 3 ColumnA ColumnB ColumnC 100/200/300 and X1/500/600/ and X2/800/900

X1= 100-500 + 300 = 100

X2 = X1- 800+ 600

Anyone know how I can make this calculation from Bex Query ??? Of course, if all the input data was in the same row that will be a easy calculation but in this case, I have to refer to cells on row above .

Any input would be appreciate.

Thanks!