Using the results of one field to calcuate the results for another field
Posted: Mon Dec 06, 2010 5:16 am
i have a report that is to provide a calcuation of depreciation of a particular set of assets. Our data set is providing the basic information (price, recovery years, start date, salvage value) and the line of the report needs to calcuate the amount of depreciation for each year as a column value.
For example a asset cost 100 and is depreciated over 4 years, the row will be:
asset description, price, method, depreciation year 1, year 2 book value, depreciation year2, depreciation year3, depreciation year4
myasset 100 SL 25 75 25 25 25
where the values are calcuated as the results of the columns of depreciation year 1 and year 2 book value, etc.
How do we do this using variables. If we use the code panel, how do we get the column values of the row to calcuate the value. This has to be done repeatively for all the records in the system.
For example a asset cost 100 and is depreciated over 4 years, the row will be:
asset description, price, method, depreciation year 1, year 2 book value, depreciation year2, depreciation year3, depreciation year4
myasset 100 SL 25 75 25 25 25
where the values are calcuated as the results of the columns of depreciation year 1 and year 2 book value, etc.
How do we do this using variables. If we use the code panel, how do we get the column values of the row to calcuate the value. This has to be done repeatively for all the records in the system.