Skip to Content
0

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

May 07 at 02:43 AM

67

avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Matthias Schober May 08 at 05:39 AM
0

Create two structures and the tab cells appears when you can define each cell seperately. With reference cells you can use each cell for your calculations

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters May 08 at 02:16 PM
0

I can't quite figure out your data, but is there a possibility to use Linked hierarchies in BW to match your result?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Koen,

Thank you for your input;unfortunatley, I am on BPC Optimize , so all hierachey debited from S/4HANA.

0
Hermann Fotso May 08 at 01:27 PM
0

Hello Matthias,

I really appreciate your input;unfortunatly, I have tried that soluation. I cannot create cell references on 300 GL accounts. Also, there is an hierachy which I would like to keep dynamic.

Please let me know your thoughts

Thanks!

Share
10 |10000 characters needed characters left characters exceeded