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!