My Day✳All blog articles ↗

Recover daily additions from running totals

Running totals cannot be added as separate daily amounts.

A running total already includes earlier additions. Subtract the previous reading from the current one to recover a period's addition. This requires a known start, consistent units and no resets or removals.

Daily additions: 3,5,4 cards; final total 12
Daily additions: 3,5,4 cards; final total 12

What to do

  1. Establish the starting count, period boundaries and that all readings concern the same retained collection.
  2. Subtract each earlier total from the next; use the known initial value for the first period.
  3. Sum the recovered additions to check the final total; do not apply the inference automatically after resets or removals.

Example

Fictional card counter starts at 0, with no resets or deletions. Daily totals: 3;8;12. Additions: 3−0=3, 8−3=5, 12−8=4; together 3+5+4=12. Adding readings, 3+8+12=23, recounts earlier cards rather than identifying 23 distinct cards.

My Day · Windows

My Day can store the table and calculation in a note. It is not presented as this counter.

Buy My Day for Windows ↗