Forum Discussion
MCFNeil
8 years agoQrew Captain
The way it displays in the relationship is an error, but it still calculates properly. Because its still a summary of any child records.
I was worried when I saw in on the details table too, but pay no bother.
I was worried when I saw in on the details table too, but pay no bother.
DavidLanglois
8 years agoQrew Member
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:
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"