Skip to Content

Data at different Levels

Newbie question... In a BEx Query I need to be able to be able to calculate the 'Calc' column below please? The Costs are at Group level and need to be applied to the Volume at Material level. I hear this should be achievable in a BEx query.

j1wvq.png (4.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 06 at 10:47 AM

    Hi Al,

    make a copy of your cost column

    put in a restriction to Material = # with constant selection

    you can hide this column, but use it in the formula for column calc.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06 at 09:24 AM

    HI,

    is the group an attribute of material ?

    if yes you should simply be able to multiply volume by cost.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06 at 10:47 AM

    Hi Al,

    make a copy of your cost column

    put in a restriction to Material = # with constant selection

    you can hide this column, but use it in the formula for column calc.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded