# 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

##### Surendra Kumar Reddy Koduru 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