Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

need help in query

Hi All,

I have to develop a report for vendor evaluation.

fields are like this: Vendor, Average price,total supply,rejected, accepted, price rating

Formula for price rating is :Price Rating = If Price of a Vendor for a material is lowest than weightage= 40

SecondLowestVendorforamaterial = WeightageofFirstLowest Vendor - (Avg.PriceofSecondVendor u2013

Avg.priceofFirst Vendor) / Avg.Priceoffirst vendor ) *100

Can anybody tell me how to implement this whole scenerio ???

Regards

Shweta

Edited by: Arun Varadarajan on Apr 10, 2009 6:22 PM

Former Member
Former Member replied

Hi,

I hope there are Two main Formulas you are looking.

1.Formula for price rating is :Price Rating = If Price of a Vendor for a material is lowest than weightage=

40

2.SecondLowestVendorforamaterial = WeightageofFirstLowest Vendor - (Avg.PriceofSecondVendor u2013

Avg.priceofFirst Vendor) / Avg.Priceoffirst vendor ) *100

Please divide the formulas into small formulas and then implement.

Price Rating = If Price of a Vendor for a material is lowest than weightage= 40

You need to create Formula for weightage.

SecondLowestVendorforamaterial = WeightageofFirstLowest Vendor - (Avg.PriceofSecondVendor 
u2013     Avg.priceofFirst Vendor) / Avg.Priceoffirst vendor ) *100

First calculate Avg.PriceofSecondVendor

Avg.priceofFirst Vendor

in separate formulas and then use in another formula to get required result.

Thanks

Reddy

Edited by: Arun Varadarajan on Apr 10, 2009 6:22 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question