It’s absolutely making sense, Sam but when I used your formulas of 23rd of March in my example-file it seems to be correct. When I put these formulas in data from 2003 until 2018 I’ve got some differences in the calculations.
New Customers Total (old) -/- Lost Customers +/+ New Customers Total = New Customers Total (new)
The reason for this was the return of some customers. We’ve counted them as lost but they returned.
Also the following calculation of the Sales was incorrect:
Total Sales (old) -/- Customer Revenue Lost -/- Lost Sales Steady +/+ Won Sales Steady +/+ New Customer Sales = Total Sales (new)
The reason for this was the same, the difference was the sales of the returning customers.
I’m a Finance-man, is it possible to make the numbers correct? Maybe we have to change some formulas of the 23rd of March? Or do I have to accept the differences?
With kind regards,