In our calculations for new customers and churned customers, we always calculate and store the calculated value with decimals. In our display on the UI, we only show round numbers, since it would be confusing to display a fractional new customer or a fractional churned customer.
In order to resolve the rounding over time, we employ a balancing figure in the new customer display. This technique is used widely by accountants and financial auditors.
The balancing figure is used periodically through the range of dates to ensure that your ending customers are accurate for both calculated and displayed
How the Calculations are Stored:
Displayed in Finmark: