Thanks for the reply, but it doesn't match my experience. Perhaps I'm misunderstanding what's happening?
Here's an example, with irrelevant attributes removed and numbers modified:
- Entry A has Reporting Year 2017, a cost of 100K, a prior year entry of Entry B, and a "Prior Year Cost" of 2 million
- Entry B has Reporting Year 2016, a cost of 20 million, no prior year entry, and a "Prior Year Cost" of 100K
- Entry C has Reporting Year 2018, a cost of 2 million, a prior year entry of Entry A, and no "Prior year Cost"
So - it looks like the children are ending up summarizing their parents.
