eBiss 3

Hilfe & Dokumentation

User Tools

Site Tools


en:transformation:mappings:funktionen:numerisch:round

Round

The Round() function accepts a value, the number of decimal places and the information about whether rounding up or down is performed and returns the rounded result.

Syntax:

Round(@Value, 'Number of decimal places', 'rounding type')

Number of decimal places

Default value is 0

rounding type

  • 1 = Mathematical or symmetrical rounding (to even rounding)
  • 2 = Commercial Rounding (Standard)

The distinction between commercial and mathematical rounding is relevant if a 5 is after the position to be rounded and no further digit follows. Since the 5 is exactly in the middle, the mathematical rounding is rounded up and down. It is always rounded towards the even final digit, hence the term “to-Even Rounding”. I. e.: 1.5 to 2,2.5 to 2,3.5 to 4,4.5 to 5, etc.\\
In commercial rounding, a 5 is always rounded up.

Sample:

Code Result
Round('1.999', '2')
2.00
Round('1.3', '2')
1.30
Round('1.445')
1
Round('1.445', '2')
1.45
Round('1.445', '2', '1')
1.44
Round('1.445', '2', '2')
1.45
Round('1.455', '2', '1')
1.46
Round('1.455', '2', '2')
1.46
en/transformation/mappings/funktionen/numerisch/round.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1