background:
We have goals for our top 50 companies; this goal is housed on the Consolidated Name object that is related to each customer record.
example: Consolidated Name= Pfizer, each Customer record for every division or location of Pfizer would have that Consolidated Name assigned to it. The goal is associated with the Consolidated Name and is the total for all Pfizers. We'd like to have this goal in one place and not on every single customer record. Is this possible?
I need to take the sum projected totals ({opportunity.projectedamount}) of all won opportunities for all Pfizer customers and divide by their goal ({custentity_ng_consolidated_name.custrecordcustrec_2020goal}) to get % to goal. (repeat for all customers)
But I cannot get the formula to work correctly.
I'm using Formula (percent) field and a sum calculation with this formula
{opportunity.projectedamount})/{custentity_ng_consolidated_name.custrecordcustrec_2020goal}
It returns an error message and I've tried every variation of this that I can think of. Any help would be greatly appreciated.