Good da Community
I am battling with a report I have been working on for ages. It was originally written by someone else but has never wired correctly. I have at last managed to get the columns to have the correct data, but some of the totals are duplicating, i.e. Aquisition Cost, Closing Cost & Depreciation.
I suspect that the joins between tabes are the problem. I would appreciate it if one of you experts would check these joins and advise.
These are the formulae that are incorrect:
Acquisition Cost - by Class - =$BeginningAmount; Total Report - =$TotalBeginningAmount
Closing Cost - by Class - =$ClosingCost; Total Report - =$TotalClosingCost
Depreciation for the Period detail - =Sum(iif([FAHistoryByPeriod.FinPeriodID] = [FAHistoryByPeriod.LastActivityPeriod], [HistoryLast.PtdDepreciated], 0)) - this formula worked in a previous version before FABookBalance table was added.
Any advise you could give regardug the table jjoins would be greatly appreciated.
Regards
Barbara
