on 12-04-2017 9:35 AM
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.
Hi,
I guess you rather need a restricted keyfigure in stead of a calculated one.
rkf= GL_AMount and AMount type = 'S'
Grtz
Koen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.