I would like to request your assistance in finding an elegant solution for a calculation case involving the relationship between a “deal” and a “company” object.
I’m interested in automating a calculation for the “current plan price” property on the “company” object based on the values associated with the deals. Additionally, I’d like to adjust the duration time from deals to the company.
A company can have multiple deals, each with properties such as “Start date of license” and “End date of license.” I want to include only those deals with an “End date of license” in the future in the calculation and exclude them as soon as the date becomes “yesterday.”
These deals come in various types, including “New,” “Renewal,” “Upgrade type 1 or type 2,” and “Downgrade type 1 or type 2.” I want the system to recognize and “tag” the applicable deal types that contribute to the “current plan price” on the company.
For example, if a client had a “renewal” for $100, followed by an “upgrade 1” for $50, and later a “downgrade 2” for -$20, the “current plan price” on the company should be calculated as $100 + $50 - $20 and “tagged” as “Renewal,” “Upgrade 1,” and “Downgrade 2.”
In the end, we need a total calculation for the company, including only data from the deals which are valied as of “today.” (“End date” in the future)
Any tips or insights you can provide would be highly appreciated!
P.S. We use Sales Enterprise and other Starter Hubs.
Hi @Anonymous,
Thank you for reaching out to the Community!
First, I’d like to share these resources that might be of interest to you:
- How to create a ‘Today’s date’ date property.
- The “Tick Tock Today” integration
I also wanted to invite a couple of subject matter experts to this conversation @danmoyle, @Shadab_Khan and @HFisher7 do you have suggestions to help @Anonymous, please? Also, if anybody else has anything to add and/or share, please feel free to join in the conversation
Thank you in advance and enjoy the day!
Best,
Bérangère
@Anonymous - There is quite alot to digest in your request but I believe this is do-able.
First, I would set up a workflow to update a custom deal property called something like ‘Active license’ when the ‘End date of license’ is in the future. You can then use this as the conditional property when creating a custom company calculation property ‘current plan price’, which sums up the value in the amount property of deals associated to the company, to only include deal records for ‘active license’ deals.
Next, I would create a workflow that re-enrols companies whenever the ‘current plan’ calculation property is known. Clears the ‘Current plan’ multi-check box property then works through a series of if/then branches to append the property with the relevant tags (Renewal, Upgrade type 1 etc).
Reach out if you have any questions or see any flaws in this suggestion
