I have a subscription-based service where clients pay us monthly. If a client cancels their subscription after 3 months, and I change the billing terms from "renewed until canceled" to a fixed term of 3 payments, I expect the Monthly Recurring Revenue (MRR) to become zero after cancellation.
However, this doesn't seem to be the case in HubSpot.
How should I handle MRR calculation in HubSpot when there is churn in a subscription model?