Skip to Content

BEx Related Query

Dec 01, 2017 at 09:51 AM


avatar image

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.

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

1 Answer

Best Answer
Frédéric Cincet 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).



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

Thank you Frédéric Cincet....

I have one more doubt regarding Formula Variable.

Account_Type have Alphabetic values. Can Formula Variable return a char value like S, K, N, D etc. If not how I am going to write following expression in calculated KF.

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


Yes, char types are supported by formula variable.

Note that Koen Hesters gave you another interesting possibility (use a restricted KF rather than a calculated one).


Hi Cincet,

I have a doubt that how we can create a expression in Restricted Keyfigure.


Well, you can't. But the expression you want is equivalent to a restricted kf on gl_amount with all account types excluding the S.