Capturing and Calculating the Difference in Value Between Two Property Updates

Smart CRM & Sales Hub Dashboards & Reporting
,
1

Hi HubSpot Enthusiasts,

I am trying to figure out a way to capture and calculate the difference between the latest 2 value changes in the same property (screenshot below).

I’m trying to store the second to last change in an additional property, then use a calculated property to subtract the latest value from the second to last one and show the difference. I’ve tried multiple approaches but none of them worked.

Any Ideas?

Thanks in advance!

image 5.png
image 5.png1025×749 86.3 KB

2

Hi @PPenev_1,

This requires one additional property and workflow in the workaround you’ve already explored.

Let’s assume your property is called ‘Number’.

  1. Create an additional custom property ‘Number (delayed by 1 minute)’
  2. Create a workflow that re-enrolls the record when ‘Number is known’, then delays 1 minute, then copies the value to ‘Number (delayed by 1 minute)’
  3. Create a calculation property, ‘Difference (calculation)’ to calculate the difference between ‘Number’ and ‘Number (delayed by 1 minute)’
  4. Create an additional property, ‘Difference (static)’
  5. Create a workflow that re-enrolls records when ‘Difference (calculation) is known AND Difference (calculation) is not equal to 0’, then copy the property value into ‘Difference (static)’

One minute delay might not be enough, so you might want to try 2 or 3 minutes if it isn’t working.

Have a look and let me know if you have any follow-up questions!

3

@karstenkoehler Thank you so much! Your method worked like a charm : )