I know this is probably something stupid, but one of my users opened a consolidating region node with 3 district totals. The number for one of the districts is different than if you opened that district with all the locations. The difference is one location. Only one of the columns (Forecast) doesn't agree. The numbers are fine for Budget and Prior Month Actual. What am I missing.
Example
REGION 100
District 1 50
District 2 50
District 1 75
Area 1 25
Area 2 50
I'd check access tables. Possible NO DATA against intersection with Forecast.
Thanks, that's certainly a possibility. I haven't touched this application in months.