Formularound( 'Copper Weight' * lookup(source="datasets", name="Commodity Indexes", result="Index Price", match_by=['Copper Index':'Index Code'], sort_by="-Effective Date", agg="first") + 'Zinc Weight' * lookup(source="datasets", name="Commodity Indexes", result="Index Price", match_by=['Zinc Index':'Index Code'], sort_by="-Effective Date", agg="first") + 'Conversion Cost', 2)
| Item | Copper Weight | Index Cost |
|---|
| BV-100 1" brass ball valve | 0.42 | $6.04 +3.1% |
| BT-075 3/4" brass tee | 0.21 | $2.69 +3.1% |
| BE-050 1/2" brass elbow | 0.12 | $1.72 +3.0% |
| BG-200 2" brass gate valve | 1.35 | $16.44 +3.6% |
| BU-075 3/4" brass union | 0.28 | $3.31 +3.8% |