So i have a product and services list. Most of the products and services are supplied by other companies and I just add a % in the "HKDJ_%" field and include it in the cost estimate. However, there are some services (and in the future, products) which are and will be supplied by my company "HKDJ Limited".
I have a "Supplier" field where the supplier name can go. I also have an "HKDJ_Item" calculation field [Cost_Price * HKDJ_%] and also a summary field called "HKDJ_Total" that adds all the "HKDH_Items' together.
The problem is that when my company (HKDJ Limited) is the "Supplier", then obviously I don't put a percentage on top of the "Cost_Price" field and consequently, the "HKDJ_Total" field result is inaccurate.
Basically, if the "Supplier" = "HKDJ Limited" then I want the "HKDJ_%" to be 0 (zero) (and it can't be changed) and I want the "HKDJ_Total" = "HKDJ_Item * Quantity", else I want "HKDJ_%" to = what was originally entered and I want "HKDJ_Total" = "Cost_Price * Quantity"
I hope that makes sense.
I tried it out myself (see below), but the fields are displaying "?".