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`