function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
gregj777gregj777 

Multiple Opportunity amounts under contract object

I am creating an events management application so that the user can create multiple opportunity events. I want to be able to total the value of the events opportunties and track it under the contract. I am having difficulties being able to total opportunity amounts as you can't use the roll-up summary option in Contract object. Also each one these opportunities is tied to a Campaign.

Does anyone have a suggestion or another option on how to do this a better way? See example below:

Create Opportunity for each event.

Oppty Event 1 = $100 link to Campaign A

Oppty Event 2 = $200 link to Campaign B

Oppty Event 3 = $300 link to Campaign C

Oppty Event 4 = $400 link to Campaign D

Oppty Event 5 = $500 link to Campaign E

Oppty Event 6 = $600 link to Campaign F

 

Create Contract

Account purchases an event package for example GOLD = $15K and you get 6 events.

So I want to be able to track the total opportunity amounts and balance.

Event Package GOLD = $15,000

Total Opportunities = $10,000

Balance = $5,000

 

Let me know if you need further clarification.