How to properly calculate sub points?

But I do have to ignore some, if someone upgrades their sub to 9.99 from 4.99 it will still show both of these until the original tier expires, and when I tried without excluding the old tier the numbers were way off, as soon as I removed all old tiers, the numbers were somewhat correct.

However, the numbers are still off…