Previous Topic

Next Topic

Book Contents

Book Index

SQL Number Functions

Function

Description

Abs

Returns the absolute numeric value of a number.

AmountDecimals

Returns the number of decimal places used to display all financial values and totals in base currency.

CostPriceDecimals

Returns number of decimal places used to display cost prices in base currency.

Fix

Returns the integer portion of a number, rounded toward zero.

Floor

Returns the integer portion of a number, rounded away from zero.

FormatNumber

Formats a number as a string.

Margin

Calculates a margin percentage from parameters.

Markup

Marks up a price by a percentage.

MaxNumber

Returns the maximum from a list of parameters.

MinNumber

Returns the minimum from a list of parameters.

Percent

Calculates percentage from parameters.

PriceDecimals

Returns the maximum of CostPriceDecimals and SellPriceDecimals for base currency.

QuantityDecimals

Returns number of decimals places used to display all item quantities.

Ratio

Calculates the ratio of two numbers.

Rnd

Returns a random number between 0 and 1.

Round

Rounds a floating point number to an integer.

RoundDown

Rounds a number downwards to a set number of decimal places.

RoundUp

Rounds number upwards to a set number of decimal places.

SellPriceDecimals

Returns number of decimal places used to display sell prices in base currency.

Sgn

Sign of a number.

StringToNumber

Converts a character string to a number.

In This Section

Abs - SQL Function

AmountDecimals - SQL Function

CostPriceDecimals - SQL Function

Fix - SQL Function

Floor - SQL Function

FormatNumber - SQL Function

Margin - SQL Function

Markup - SQL Function

MaxNumber - SQL Function

MinNumber - SQL Function

Percent - SQL Function

PriceDecimals - SQL Function

QuantityDecimals - SQL Function

Ratio - SQL Function

Rnd - SQL Function

Round - SQL Function

RoundDown - SQL Function

RoundUp - SQL Function

SellPriceDecimals - SQL Function

Sgn - SQL Function

StringToNumber - SQL Function