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
Alex ValavanisAlex Valavanis 

formula for renewal rate

I want to see which accounts had revenue in one year and which not in another. Also report on which accounts we have lost/cancelled or gained Year over Year.
I am looking for a result which will give me a renewal rate of 84% for 2017.
Formula i am looking for is: (2016 closed won - total closed lost) / 2016 closed won = 84%
In other words : (1.382.279 - 214.464) / 1.382.279 = 84%
Any ideas?

User-added image