Syd (PQL)

Returns the sum-of-years' digits depreciation of an asset for a specified period.

  • Returned Output: Numeric
  • Library: PQL \ Common \ Financial
  • Version: 2025.01.000
  • Compatibility:
    • It can be combined with other PQL functions throughout the application.
    • It CANNOT be used with MDX or VBA functions. But it can be used on MDX-based content in other parts of the application.

Syntax

Syd( <Numeric> , <Numeric> , <Numeric> , <Numeric> )

* Click on the function's arguments above for more details on the input values.

Comments

This function is the same as the Microsoft Excel 'SYD' function - using the same inputs, logic, and outputs.

Function Arguments

Name

Description

Type

Optional

cost

Initial cost of the asset.

<Numeric>

 

salvage

Value at the end of the depreciation.

<Numeric>

 

life

Number of periods over which the asset is being depreciated.

<Numeric>

 

per

Period for depreciation; must use the same units as the life argument.

<Numeric>

 
Example

This example calculates the depreciation expense for the 12th period of an asset using the Sum-of-Years'-Digits (SYD) method. The asset has an initial cost of [measures].[Data Sales], a salvage value of half that amount ([measures].[Data Sales]/2), and a total useful life of 12 periods.

Syd( ([measures].[Data Sales]), ([measures].[Data Sales])/2, 12, 12 )