I have a Budget Entries table where each record represents one year. I've joined this table to itself because I need to capture the prior year's gross budget impact (year N needs to know the impact of N-1).
When I try to add a summary field to the master Budget Entry in the relationship, a field named Prior Year Budget Gross, it gets added, instead, to the detail.
The effect of this is that my "Prior Year Budget Gross" is behaving as a "Next Year Budget Gross" instead, but if I add the "Budget Entries" default report to a Budget Entry, it appropriately shows its prior year.
Has anyone run into this before? Is it expected behavior that I just wasn't expecting? Is there another way to solve this problem?
Thanks in advance for any assistance.