Hi,
Currently, I am using PHPRunner to do a purchasing list but I am having problem calculating the value automatically.
I have a few columns and example value as below:
a. Date of purchase: 12/10/2012
b. Useful life(months): 12
c. Buying Price: 4000
d. Depreciation Price: Buying Price (4000) / Useful life (12) = 333.33 (for 1st 11 month) and 333.37 (for the 12th month)
I am abled to do the auto calculation when the first record is created and the 1st 11 months the value will be 333.33. However, on the last month, how can I change the value from 333.33 to 333.37 automatically?
Can someone please kindly advice on this? Thanks.