| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
BI REPORT
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
| Print Report W/Sub Report | Excel Discussion (Misc queries) | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| Header in Report Manager Report | Excel Discussion (Misc queries) | |||
| =(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) | |||
Threaded Mode
