Previous Topic

Next Topic

Margin - SQL Function

Margin(A: Number, B: Number): Number

Calculates margin from parameters as follows,

Margin(A, B) = ((B - A) / B )*100.
Divide by zero returns zero.
If A and B are of opposite signs returns zero.

Margin function syntax has these named arguments:

Parameter

Description

A

Required. Number to determine the margin from.

B

Required. Number to determine the margin to.

See Also

SQL Number Functions

Book Contents

Book Index