Skip to Content
0
Former Member
Dec 03, 2008 at 09:48 PM

BEx Formula Calculation and RESULT Display!

292 Views

Hi All,

I am trying to simple calculation in BEx query based on two KF.

KF1(Qty),KF2(Price),CKF(Amount)

Amount is not calculated in CUBE I am trying to do this in query level.

I am facing problem at the result level. Sample query display.

CompCode | Material | KF1(QTY) | KF2(Price) | CKF(Amount)=KF1*KF2

ABC | TAPE | 3 EA | $ 100 | $ 300.00

ABC | BLADE | 10 PC | $ 50 | $ 500.00

________________________________________________

RESULT 800.00

But problem come when I remove Material from Drill Down my claculation goes WRONG. Its showing

CompCode | KF1(QTY) | KF2(Price) | CKF(Amount)=KF1*KF2

ABC | 13 | $ 150 | $ 1950.00

______________________________________________

RESULT 1950.00

Still it should show $800. IS ther anyway I can achieve this in REPORT (Tried FORMULA COLLISION - no use).

Thanks in advence for HELP!