Hi,

I have a requirement , I have posted thread but not getting solution and its
urgent so I am sending mail...

If u can help me then I will be really thankful to you.



I want to develop a report "Vendor evaluation" ..
I have keyfigure invoice amount and invoice quantity... and characteristic
Material and vendor
then have to calculate wtd avg price by formula( invoice amount/invoice
quantity).
Now i got one more column wtd avg price...
Report layout is





material vendor inv value invoice quan wtd avg price price rating
M1 V1 45 15 3
V2 40 15 2.6 40
V3 60 12 5
v4 80 12 6.6


As you see above.. for Material M1, four vendors are there , and v2 is
giving material at lowest price so his rating is 40
v1 is second lowest so his rating will be calculated by formula Weightage
ofFirst Lowest Vendor(i.e V2) - (Avg.Price of Second Vendor(v1) €“ Avg.
price of First Vendor) / Avg. Price of first vendor ) *100


How to implement this scenerio... pls help ...


REGARDS