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.

CalcMarkup

Calculates markup percentage from parameters.

CostPriceDecimals

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

Fix

Returns the integer portion of a number. Negative numbers round up (towards 0).

FormatNumber

Formats a number as a string.

FormatQuantity

Formats a number with Quantity Decimals, optionally for UOM.

Int

Returns the integer portion of a number. Negative numbers round down (away from 0).

Margin

Calculates margin from parameters.

Markup

Marks up a price by a percentage.

Max

Returns the maximum from a list of numbers.

Min

Returns the minimum from a list of numbers.

Percent

Calculates percentage of a number verses another number.

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 number to a set number of decimal places.

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.

UOMDecimals

UOM Item Quantity Decimal places.

Val

Returns a number representing the value of a string.

VariancePercent

Returns (Budget - Actual)/Budget * 100 with variance sign matching.