As I understand to calculate retention rate we need three pieces
Retention Rate = ((CE-CN)/CS)) X 100
CE = number of customers at the end of period
CN = number of new customers acquired during period
CS = number of customers at start of period
Is this the formula you are using?
Also, it would be easy to help you if you provide a mock up data and a .twbx file, telling us what the expected result is