Search
Search

# 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 Kodurureplied

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
View more on this topic or