Bring the inputs together on the model.
List price comes from the Contractor Q1 2027 price list. The customer’s program discount and contract prices come from datasets loaded from your agreements. Each is a lookup, matched on customer and item.
| Name | Type | Formula |
|---|---|---|
| Customer | Text | From data |
| Unit Cost | Money | From data |
| List Price | Money | lookup(source="pricelists", name="Contractor Q1 2027", result="List Price", match_by=['Item Number':'Item Number']) |
| Program Discount | Percentage | coalesce(lookup(source="datasets", name="Customer Programs", result="Discount", match_by=['Customer':'Customer', 'Product Group':'Product Group']), 0) |
| Contract Price | Money | lookup(source="datasets", name="Customer Contract Prices", result="Contract Price", match_by=['Customer':'Customer', 'Item Number':'Item Number']) |