+ 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!