Skip to Content
0
Former Member
Nov 07, 2005 at 09:34 PM

Bex overall result,result(Aggregation)based on the characteristics selec

31 Views

Hi,

Here is my query requirement:

Formula KF-> Priceperpiece05 = Sales 05(RKF)/Qty 05(RKF)

And BaseSales(Formula KF)= Priceperpiece05 * Qty 06(RKF)

Cust |Material | (Priceperpiece05) | BaseSales

1 102091 $2.72 /PC $54.40

1 102098 $1.03 /PC $12.36

Overall result $2.27/pc $66.76

This works fine with cust-material combination.If i remove the material in the query, the customer overall result shows different basesales value(due to the after aggregation).

Is there any way i can get the correct overall results without the material in the query?

regards,

ravi

Message was edited by: Ravi