function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
GSNLGSNL 

Calculation formula

Hi,
 
I have created a custom Tab called Iinvoices, where i would have multiple Invoices for a single Opportunity.
the Unique field that connects an Opportunity to an Invoice is "Purchase_Order_Number".
 
I am woundering if I can calculate the total of all the Invoices for a particular Purchase_Order_Number.
 
Please help
 
Thanks & regards,
Ganesh SN Lekshman
FreshFresh
GSNL wrote:
Hi,
 
I have created a custom Tab called Iinvoices, where i would have multiple Invoices for a single Opportunity.
the Unique field that connects an Opportunity to an Invoice is "Purchase_Order_Number".
 
I am woundering if I can calculate the total of all the Invoices for a particular Purchase_Order_Number.
 
Please help
 
Thanks & regards,
Ganesh SN Lekshman




Hi,

The field that is connecting your invoice to the Opportunity should be a Lookup Relationship to the Opportunity on the Custom Object. If you make this relationship you can then have a Roll-Up field on the Opportunity that will calculate the total of all of your invoices.

Hope this helps!