Skip to Content

Calculated KF & Formula Variable Issue

Dec 04, 2017 at 09:35 AM


avatar image
Former Member

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

I can create a formula Variable to make the Account_type available in Calculated KF.

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 above given expression in calculated KF.

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

1 Answer

Koen Hesters Dec 04, 2017 at 10:04 AM


I guess you rather need a restricted keyfigure in stead of a calculated one.

rkf= GL_AMount and AMount type = 'S'



Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Koen,

Thank you responding.

I have a doubt that how we can create expression in restricted KF.

new Key Figure "Total_GL_Amount" should have following expression

if Account_Type = S then GL Account = 0 else GL_Account


so you want 0 in stead of spaces, well, create a calculated KF upon the restrcited and use formula: restrcited KF +0

so you will have 0's in your report

and if S for you is GL accouont = 0 then change your restrictiction filter to H