Hi All,
I have a client that is interested in tracking the changes in deal amount for deals in their pipeline. They want to track their initial deal value that is proposed, then adjust with the actual contract value. They also want to be able to report on the spread between the two on net new business. Would this be best to track using two new properties, or with a workflow automation to timestamp and record the deal amount value as time moves on, or maybe something else? I appreciate any reccomendations!
Hi @Caseyhg,
Two properties would indeed be helpful - so you can create a third property (calculation for the spread).
- Deal amount (default property)
- First deal amount (updated via a workflow that enrolls deals once when their deal amount is greater than 0, then copies the value into first deal amount)
- Deal amount spread (a calculation property with type number and a custom equation: deal amount minus first deal amount)
This would be fully automated, doesn’t require a change in process (everyone still works with the default deal amount field) and the detailed change history is still visible on the default deal amount, if needed: View a record's property history
Hope this helps!
PS. I’d recommend limiting the workflow to deals created from now on only for valid data.
Thank you Karsten, I will try to set this up shortly! I appreciate the help, Happy Halloween!