Ddb (PQL)

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.

  • 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

Ddb( <Numeric> , <Numeric> , <Numeric> , <Numeric> , OPTIONAL <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 'DDB' 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 depreciation.

<Numeric>

 

life

Number of periods over which the asset is being depreciated.

<Numeric>

 

period

Period for which you want to calculate the depreciation in the same units as the life argument.

<Numeric>

 

factor

Rate at which the value declines; if omitted, the calculation uses 2 (double-declining method).

<Numeric>

Y
Example

This example calculates the depreciation in the first period for an asset that originally cost whatever the Data Sales value is, will end with a salvage value equal to half of that, over a yearly lifespan, using the double-declining balance method:

Ddb( ([measures].[Data Sales]), ([measures].[Data Sales])/2, 1, 1 )