Group Math
-
Minus operator (unary): reverses sign of operand (multiplies operand by -1). Minus operator (binary): numeric subtraction or string concatenation.
<nValue1> - <nValue2> // subtraction <dDate1> - <dDate2> // subtraction <dDate> - <nValue> // subtraction <cString1> - <cString2> // string concatenation
--
Decrement operator (unary): subtracts one from a numeric or date value.
--<VarName> // Prefix decrementing <VarName>-- // Postfix decrementing
%
Modulus operator (binary): determines the remainder of a division.
<nValue1> % <nValue2>
*
Multiplication operator (binary): performs numeric multiplication.
<nValue1> * <nValue2>
**
Exponential operator (binary): exponentiation of a numeric value.
<nValue> ** <nExponent> // or <nValue> ^ <nExponent>
/
Division operator (binary): performs numeric division.
<nValue1> / <nValue2>
+
Plus operator (unary): defines the sign of numeric values. Plus operator (binary): numeric addition or string concatenation.
<nValue1> + <nValue2> // addition <dDate> + <nValue> // addition <nValue> + <dDate> // addition <cString1> + <cString2> // string concatenation
++
Increment operators (unary): increase numeric or date value by one.
++<VarName> // Prefix incrementing <VarName>++ // Postfix incrementing
Abs()
Determines the absolute value of a numeric expression.
Abs( <nExpression> ) --> nPositive
Acos()
Calculates the arc cosine.
Acos( <nCosine> ) --> nArcCosine
Asin()
Calculates the arc sine.
Asin( <nSine> ) --> nArcSine
Atan()
Calculates the arc tangent.
Atan( <nTangent> ) --> nArcTangent
Atn2()
Calculates the radiant of an angle from sine and cosine.
Atn2( <nSine>, <nCosine> ) --> nRadiant
BAnd()
Calculates the result of a bitwise AND operation.
BAnd( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseAnd
BOr()
Calculates the result of a bitwise OR operation.
BOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseOr
BXOr()
Calculates the result of a bitwise XOR operation.
BXOr( <nVa1>, <nVal2>, [<nVal3>,...] ) -> nBitwiseXOr
Cos()
Calculates the cosine for an angle.
Cos( <nRadiant> ) --> nCosine
Cot()
Calculates the cotangent.
Cot( <nRadiant> ) --> nCotangent
Descend()
Gives an inverted index key value for sorting in descending order.
Descend( <Expression> [,<lCompatible>] ) --> DescendValue
DtoR()
Converts an angle from degrees to radiant.
DtoR( <nDegree> ) --> nRadiant
Exp()
Calculates the value of e to the power of x
Exp( <nExponent> ) --> nAntilogarithm
Fact()
Calculates the factorial of a number.
Fact( <nNumber> ) --> nFactorial
Floor()
Rounds a number to the next smaller integer.
Floor( <nNumber> ) --> nInteger
Fv()
Calculates a Future Value.
Fv( <nPayment>, <nInterestRate>, <nNumberOfPayments> ) --> nFutureValue
Int()
Converts a numeric value to an integer numeric value.
Int( <nExpression> ) --> nInteger
Log()
Calculates the natural logarithm of a numeric value.
Log( <nExpression> ) --> nNaturalLog
Log10()
Calculates the base 10 logarithm.
Log10( <nNumber> ) --> nLog10
Max()
Determines the larger of two numeric or two date values.
Max( <ndExpression1>, <ndExpression2> ) --> ndMax
Min()
Determines the smaller of two numeric or two date values.
Min( <ndExpression1>, <ndExpression2> ) --> ndMin
Mod()
Determines the modulus of two numbers in the same manner as dBASE III PLUS.
Mod( <nDividend>, <nDivisor> ) --> nRest
Payment()
Calculates a periodical payment for loans.
Payment( <nLoanedCapital>, <nInterestRate>, <nNumberOfPayments> ) --> nPayment
Periods()
Calculates the number of payments for a loan at fixed interest rate and payments.
Periods( <nLoanedCapital>, <nPayment>, <nInterestRate> ) --> nNumberOfPayments
Pi()
Returns Pi at maximum precision.
Pi() --> nPi
Pv()
Calculates the Present value of a loan at fixed interest rate.
Pv( <nPayment>, <nInterestRate>, <nNumberOfPayments> ) --> nPresentValue
Rate()
Calculates the interest rate for a loan.
Rate( <nLoanedCapital>, <nPayment>, <nNumberOfPayments> ) --> nInterestRate
Round()
Rounds a numeric value to a specific number of decimal places.
Round( <nValue>, <nDecimals>) --> nRoundedValue
RtoD()
Converts angles from radiant to degrees.
RtoD( <nRadiant> ) --> nDegree
Sin()
Calculates the sine.
Sin( <nRadiant> ) --> nSine
Sqrt()
Calculates square root of a positive number.
Sqrt( <nValue> ) --> nSquareRoot
Tan()
Calculates the tangent.
Tan( <nRadiant> ) --> nTangent