Apex Code Development You need to sign in to do that
Don't have an account?
Alex Valavanis formula for renewal rate
Hi,
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?
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?