Skip to main content
Skip table of contents

Fixed Value

Description

The Fixed Value function overwrites the value of a business figure with an absolute amount. This amount can be the value of another business figure, which itself can be adjusted using the basic arithmetic operations.

Using this Function

Syntax

In the Control File, the Fixed Value function is called up as follows:

CODE
[account] = value
[account] = (value1, ..., valueN) 
[account] = [referenceAccount] operator value 

Parameters

[account]

Business figure for which the value should be calculated.
This must be contained in the following input data: Input Files | Financial-Data

value

Denotes the absolute amount with which the old value of the business figure is to be overwritten.

(value1, value2, ..., valueN)

Denotes a list of absolute amounts with which the old value of the business figure is to be overwritten.
Here, value1 is used for the first calculation date, value2 for the second calculation date, etc.

operator

Stands for one of the basic arithmetic operations +, -, *, /.

[referenceAccount]

Denotes the business figure whose value is to be used for overwriting.
This must be contained in the following input data: Input Files | Financial-Data

Examples

The examples below are based on the following data:

  • value of the business figure [10003]: 47,600.00

  • value of the business figure [10003]: 12,400.00

Example 1

CODE
[10003] = 50000
  • new value of the business figure [10003]: 50,000.00

Example 2

CODE
[10003] = (50000, 51000, 52000)
  • new value of the business figure [10003] on the first calculation date: 50,000.00

  • new value of the business figure [10003] on the second calculation date: 51,000.00

  • new value of the business figure [10003] on the third calculation date: 52,000.00

Example 3

CODE
[10005] = [10003] * 0.3
  • new value of the business figure [10005]: 47,600.00 * 0.3  = 14,280.00

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.