Skip to Content
avatar image
Former Member

Calculated KF & Formula Variable Issue

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 10:04 AM

    Hi,

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

    rkf= GL_AMount and AMount type = 'S'

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

    • 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