Show TOC

Functions with Three OperandsLocate this document in the navigation structure

Function

Meaning

Operand1; ... ; Operand3

DISC

Discounting

Formula for discounting an amount: Result = key figure value / ((1 + interest rate / 100) ** years)

Key figure; Interest rate; Years

DECD

Declining-balance depreciation

This functions calculates according to the following algorithm:

  1. "Perform [number of years] times: Intermediate value = intermediate value + (start value - intermediate value) * percentage / 100"

  2. Result = start value - intermediate value

Start value; Percentage; Years;

ATRVT

Read time-dependent attribute

Attribute type; Variable; Date

SUBSTR

Read substring

Variable; Offset; Length

REPLACE

Replace character

Source string; Pattern; Replacement

Note

  • Function DISC discounts an amount according to the following formula:

    Result = key figure value / ( ( 1 + interest rate / 100 ) ** years )

  • Function DECD calculates a declining-balance depreciation according to the following algorithm:

    1. Perform [number of years] times.

      Intermediate value = intermediate value + ( start value - intermediate value ) * percentage / 100.

    2. Result = start value - intermediate value