Using the results of one field to calcuate the results for another field

[ebeser]

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.

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?
Also please send us a report sample or a report template for bettere understanding the task.

Thank you.