In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
Cost = 35000
Salvage = 3000
Life = 10
Period = 5
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the SYD function, and returned the sum-of-years depreciation value.
Name
SYD
Syntax
SYD (Real Cost, Real Salvage, Real Life, Real Period)
Purpose
To return the sum-of-years depreciation of an asset for a specified period.
Description
Returnsthe sum-of-years depreciation of an asset for a specified period.
Return Type
Double
Parameters
Cost [System.Double]
Salvage [System.Double]
Life [System.Double]
Period [System.Double]
