Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Depr

Use this function to calculate depreciation amounts.

Syntax:

DEPR ("DB", Source, Rate/Life, "Compute"[, OpeningBalance], [Salvage])

where:

  • Source is a symbol or value representing the value of the asset being depreciated.
  • Rate is either a number expressed as a percentage or number of periods. This must be a number between 0 and 1.
  • Compute indicates whether the period (PD) or year-to-date (YTD) depreciation is calculated (only YTD is supported currently). This parameter must be enclosed in double quotation marks.
  • OpeningBalance is a value repesenting the opening balance for the depreciation calculation.
  • Salvage is a value representing the salvage value of the asset.

Syntax example:

DeprVal=DEPR("DB", A1000, 0.97, "YTD", 5000, 10)
Published:

Depr

Use this function to calculate depreciation amounts.

Syntax:

DEPR ("DB", Source, Rate/Life, "Compute"[, OpeningBalance], [Salvage])

where:

  • Source is a symbol or value representing the value of the asset being depreciated.
  • Rate is either a number expressed as a percentage or number of periods. This must be a number between 0 and 1.
  • Compute indicates whether the period (PD) or year-to-date (YTD) depreciation is calculated (only YTD is supported currently). This parameter must be enclosed in double quotation marks.
  • OpeningBalance is a value repesenting the opening balance for the depreciation calculation.
  • Salvage is a value representing the salvage value of the asset.

Syntax example:

DeprVal=DEPR("DB", A1000, 0.97, "YTD", 5000, 10)
For an optimal Community experience, Please view on Desktop