cancel
Showing results for 
Search instead for 
Did you mean: 

Calculated KF & Formula Variable Issue

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

kohesco
Active Contributor
0 Kudos

Hi,

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

rkf= GL_AMount and AMount type = 'S'

Grtz

Koen

Former Member
0 Kudos

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

kohesco
Active Contributor
0 Kudos

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