Does anyone know anything about depreciation analysis? I have a large crosstab query which shows an Asset Id as a row header and roughly 300 column heads which represent Periods (Year/Month eg 200401). The crosstab value is the amount of depreciation against an asset within that period. I'm trying to analyse out a depreciation impairment across a line - i.e. where across the line, depreciation values are steady until there is one figure out of sync followed by 0s.
I'm also trying to track changes in depreciation method which shows as one value for many periods, followed by a different value, also for many periods. What I would like to do is run a procedure which would return a value of either "Impairment" or "Method" in a new field called "Error".
I'm just beginning designing modules - does anyone have a module I can use as a basis??