We have created a custom record that we’re using as a CMS to request maintenance and repairs. There are two fields… Purchase Cost and Vendor Labor Cost
…that I want to sum up in a field named TOTAL. NOTE: There are occasions when only the Labor or Purchase costs are populated – but I still need the TOTAL field populated with the cost of either field. Currently, the only way to get the total is to have it calculated during a Workflow after the record has been submitted
(TOTAL = ({custrecord_vta_cmrest_purchase_cost})+({custrecord_vta_cmrest_labor_cost})).
However, this isn’t ideal for the other steps within the Workflow.
My wish is that the field is dynamic. Meaning, when a user types the costs into either of the cost fields the Total field will show the total sum of the two. I tried to set the custom field as a default value with the formula ({custrecord_vta_cmrest_purchase_cost})+({custrecord_vta_cmrest_labor_cost}) – but this didn’t work either.
Any assistance would be appreciated!