Skip to Content

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 08 at 05:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 08 at 02:16 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • May 08 at 01:27 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded