need help in query

[Former Member]

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_member181964 · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

Thanks for ur response.

But how to calculate Avg.PriceofSecondVendor and for first vendor.

Regards

Shweta

[former_member181964 · Accepted solution]

Hi,

How can you find First Vendor and Secon Vendor?. This you need to find. Use New Selctions/Restricted Keyfigures and then find it.

Right Click on Formulas/RKF and then you can find Calculate Result = Average.....ect

Thanks

Reddy