CHANNELADVISOR.COM
How To
Home » How To » Foundations » Using Business Rules » Using Numeric Functions in Business Rules

Using Numeric Functions in Business Rules

Numeric Functions allow Business Rules to operate on numbers.   View the table below for Numeric Functions supported for Business Rules.

Prerequisites

You should be familiar with the following topics:

Numeric Functions Supported for Business Rules

 

View the table below for Numeric Functions supported for Business Rules. 

FunctionDescriptionExampleOutput
CEILINGReturns the largest whole number greater than or equal to the input number.CEILING(1.23)2
FORMATCURRENCY

Formats numeric text value to a currency type. The simple version just adds two decimal places and formats everything using United States formatting rules; the more complex version allows for other locale formats and allows the currency symbol to be exported. The simple version works as long as the decimal point is okay for the decimal symbol. Use the complex version if any of the following are true:

  • Another culture's format should be used (pass in the 4-character culture name as the second parameter).
  • The currency symbol needs to be output (pass in True for the third parameter)
  • Digit group (thousands) separators are needed (pass in True for the fourth parameter)
FORMATCURRENCY(“5”) FORMATCURRENCY(5000”,”en-GB”,TRUE,TRUE)5.00 5,000.00 
FORMATNUMBERFormats a number according to a format specification.  Use "Fx" to format to x digits after the decimal.FORMATNUMBER(2.0/3.0, "F5")0.66667
FLOORReturns the largest whole number less than or equal to the input number.FLOOR(6.54)6

 

Numeric Functions allow Business Rules to operate on numbers.   View the table below for Numeric Functions supported for Business Rules.

Prerequisites

You should be familiar with the following topics:

Numeric Functions Supported for Business Rules

 

View the table below for Numeric Functions supported for Business Rules. 

FunctionDescriptionExampleOutput
CEILINGReturns the largest whole number greater than or equal to the input number.CEILING(1.23)2
FORMATCURRENCY

Formats numeric text value to a currency type. The simple version just adds two decimal places and formats everything using United States formatting rules; the more complex version allows for other locale formats and allows the currency symbol to be exported. The simple version works as long as the decimal point is okay for the decimal symbol. Use the complex version if any of the following are true:

  • Another culture's format should be used (pass in the 4-character culture name as the second parameter).
  • The currency symbol needs to be output (pass in True for the third parameter)
  • Digit group (thousands) separators are needed (pass in True for the fourth parameter)
FORMATCURRENCY(“5”) FORMATCURRENCY(5000”,”en-GB”,TRUE,TRUE)5.00 5,000.00 
FORMATNUMBERFormats a number according to a format specification.  Use "Fx" to format to x digits after the decimal.FORMATNUMBER(2.0/3.0, "F5")0.66667
FLOORReturns the largest whole number less than or equal to the input number.FLOOR(6.54)6

 

0
Your rating: None
0
Your rating: None
  Page last updated: Mon, 07/30/2012 - 17:03