To calculate the depreciation value for the aforementioned example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
Cost = 10000
Salvage = 3000
Life = 10
Period = 6
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned depreciation value using the double-declining method.
Name
DDB
Syntax
DDB (Real Cost, Real Salvage, Real Life, Real Period)
Purpose
To return the double-declining balance of an asset.
Description
Returns the depreciation of an asset for a specific time period using the double-declining balance method.
Return Type
Double
Parameters
Cost [System.Double]
Salvage [System.Double]
Life [System.Double]
Period [System.Double]
