Versions Compared

Old Version 22

changes.mady.by.user Alexandra Aldea

Saved on

compared with

New Version 23

changes.mady.by.user Dick van Soest

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
bgColorwhite

LOG

Since 12.8

Use the 'LOG' function to calculate the logarithm of a number to a base.

Syntax

Code Block
 LOG([number], [base])

  • number- Number; number or attribute of some type of number.

  • base - Base; number or attribute of some type of number.

Return types

  • number

Examples

ExpressionResultType
LOG(100, 10)2.0Number
LOG(32, 2)5.0Number
LOG(3, 9)0.5Number


Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

ROUND

ROUNDDOWN

ROUNDUP

The ROUND function rounds a number value to a specified number of decimal places.

Syntax

Code Block
 ROUND number [UP | DOWN] TO POSITION position
  • number - Number or attribute of some type of number to be rounded.
  • UP or DOWN - The direction of rounding. The direction DOWN points to zero for both positive and negative values, UP points away from zero. If no direction is specified, rounding will be done to the nearest integer (half-way values will be rounded up).
  • position - The rounding position as integer. A positive integer represents the place value of the digit after the decimal point. Zero and negative integers represent the place value of the digit before the decimal point. Place values: [-n]..[-3][-2][-1][0].[1][2][3]..[n]

Return types

  • number
  • integer
  • currency
  • percentage
UI Text Box
typenote

If you prefer a functional syntax, then you can use the ROUNDDOWN or ROUNDUP function. Its syntax is ROUNDDOWN/ROUNDUP ( number , digits ). Example: ROUNDDOWN( 1.23456 , 2 ) = 1.23

Examples

ExpressionAlternative syntaxResultType
ROUND 12345.23 TO POSITION -2ROUNDSIG( 12345.23, 100 )12300.0000Number
ROUND 12345.23 TO POSITION 1 ROUNDSIG( 12345.23 , 0.1 )12345.2000Number
ROUND 12345.23 UP TO POSITION -2ROUNDUP( 12345.23 , -2 )12400Integer
ROUND 12345.23 UP TO POSITION 1ROUNDUP( 12345.23 , 1 )12345.3000Number
ROUND 12345.23 DOWN TO POSITION -2ROUNDDOWN( 12345.23 , -2 )12300.0000Number
ROUND 12345.23 DOWN TO POSITION 1ROUNDDOWN( 12345.23 , 1 )12345.2000Number
ROUND 12345.23 UP TO POSITION -5ROUNDUP( 12345.23 , -5 )100000.0000Number


Include Page
_nav_BackToTop
_nav_BackToTop

Panel
bgColorwhite

ROUND TO MULTIPLE

ROUNDSIG

ROUNDSIGUP

ROUNDSIGDOWN

The ROUND TO MULTIPLE function rounds a number value to a specified multiple.

Syntax

Code Block
 ROUND number [UP | DOWN] TO MULTIPLE multiple
  • number - Number or attribute of some type of number to be rounded.
  • UP or DOWN - The direction of rounding. The direction DOWN points to zero for both positive and negative values, UP points away from zero. If no direction is specified, rounding will be done to the nearest multiple (half-way values will be rounded up).
  • multiple - The multiple to be rounded to. This can be both a positive and negative value of any number type.

Return types

  • number
  • integer
  • currency
  • percentage

Examples

ExpressionAlternative syntaxResultType
ROUND 12345.23 TO MULTIPLE 500ROUNDSIG( 12345.23, 500 )12500.0000Number
ROUND 12345.23 TO MULTIPLE 5 ROUNDSIG( 12345.23 , 5 )12345.0000Number
ROUND 12345.23 TO MULTIPLE 0.50ROUNDSIG( 12345.23 , 0.50 )12345.0000Number
ROUND 12345.27 TO MULTIPLE 0.50ROUNDSIG( 12345.27 , 0.5 )12345.5000Number
UI Text Box
typenote

If you prefer a more functional syntax, you can use the ROUNDSIG, ROUNDSIGDOWN or ROUNSIGUP functions, all with 2 number parameters.

Include Page
_nav_BackToTop
_nav_BackToTop

...