Skip to Content
avatar image
Former Member

BEx Related Query

Hi All,

I am new to BEX & I would like to create a new Key Figure "Total_GL_Amount" in Query Output with following expression:

(Account_type = 'S') * 0 + (Account_type <> 'S')* GL_Amount

Where Account_type is characteristic & GL_Amount is Key figure.

Please suggest what I have to do it.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 01, 2017 at 10:21 AM

    GL_Amount is a KF. It is then available for any calculated KF.

    To make the Account_type available, just create a formula variable (type replacement path).

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded