Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
i need a formula that calculates a sum divided by one value
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)