Skip to Content
avatar image
Former Member

Formula at BEx query get wrong result

Hi,

Please I need your help in Bex query. We have key figure called Balance, this KF can be either positive or negative value. Our client requirement is to display two new key figures, one for positive amount only and the other for negative.

The Positive and negative are calculated as formula if condition, the result is good at customer level but when drill up at group customer level the result get wrong.

Please any idea to help.

result.png

result.png (8.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 10, 2017 at 06:15 PM

    Hi;

    Can you try exception aggregation (summation / customer)?

    Hope it helps;

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 10, 2017 at 01:10 PM

    Hi,

    can you check if you have a

    Debit/Credit Indicator, if not create one in the transactional flow, optionally creating KF respectively.

    this would make things easier and more transparent.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2017 at 10:23 PM

    Hi Afrain,

    You need to use some Boolean logic in your calculated key figures or formulas

    KF = key figure (can be negative or positve)

    Calculated KF_Pos = (KF > 0 ) {true} * KF = KF if positive, else 0

    Calculated KF_Neg = (KF < 0 ) {true} * KF = KF if negative, else 0

    Let us know if it works!

    John Hawk

    Add comment
    10|10000 characters needed characters exceeded