Formula at BEx query get wrong result

[former_member245426]

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

[Former Member · Accepted solution]

Hi;

Can you try exception aggregation (summation / customer)?

Hope it helps;

Regards

[john_hawk]

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

[kohesco]

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