I have a report set up in Financial Reporter that I created in consolidated, collapsed mode. It covers several departments. All the departments calculate correctly except one. That one department calculates the correct expenses when in collapsed mode but then adds in the first expense line twice when I expand the sheet. It's difficult to compare the two as the SUM range changes between the 2 sheets. I cannot see how it is pickinf up that cell twice and I have no hidden rows.
Any help would be appreciated.
Thanks