Reunir las entradas en el modelo.
El precio de tarifa procede de la lista de precios Contractor Q1 2027. El descuento de programa y los precios contractuales del cliente proceden de datasets cargados desde sus acuerdos. Cada uno es un lookup, cruzado por cliente y artículo.
| 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']) |