Functions

Absolute Value

abs(-123.45)

Returns the absolute value of a double value. If the argument is not negative, the argument is returned. If the argument is negative, the negation of the argument is returned. Special cases:

• If the argument is positive zero or negative zero, the result is positive zero.
• If the argument is infinite, the result is positive infinity.
• If the argument is NaN, the result is NaN.

Arc Cosine

acos(0.25)

Returns the arc cosine of a value; the returned angle is in the range 0.0 through pi. Special case:

• If the argument is NaN or its absolute value is greater than 1, then the result is NaN.

Arc CoTangent

acotan(0.25)

PI / 2 – ArcTangent

Alpha

alpha(0.25)

Formats a number into a alphanumeric string.

Arc Sine

asin(0.25)

Returns the arc sine of a value; the returned angle is in the range -pi/2 through pi/2. Special cases:

• If the argument is NaN or its absolute value is greater than 1, then the result is NaN.
• If the argument is zero, then the result is a zero with the same sign as the argument.

Arc Tangent

atan(0.25)

Returns the arc tangent of a value; the returned angle is in the range -pi/2 through pi/2. Special cases:

• If the argument is NaN, then the result is NaN.
• If the argument is zero, then the result is a zero with the same sign as the argument.

Banded Rate

BandedRate("myTable", "09/07/2011", 125,256.36)

/*
 * Only the last key in the table is used for banded
 */
Hashtable<Double, Double> rateTable =
    resolveRate(
      tableName,
      ratesgetEqu().getBaseDate(),
      baseAmount.doubleValue())

Flat Rate

Rate("myTable", "09/07/2011")

double rate =
    model.resolveRate(
      tableName,
      getEqu().getBaseDate(),
      keys[0],
      keys[1],
      keys[2],
      keys[3],
      keys[4]);

If

if(myVar='C', cos(myAngle), sin(myAngle))

Returns the first value if the condition is true, otherwise it returns the second value.

Maximum

max(1, 2, 3, 4, 5)

Each of the multiple items are compared with each other.

Returns the greater of two double values. That is, the result is the argument closer to positive infinity. If the arguments have the same value, the result is that same value. If either value is NaN, then the result is NaN. Unlike the numerical comparison operators, this method considers negative zero to be strictly smaller than positive zero. If one argument is positive zero and the other negative zero, the result is positive zero.

Round

round(1.49)

Returns the closest long to the argument. The result is rounded to an integer by adding 1/2, taking the floor of the result, and casting the result to type long. In other words, the result is equal to the value of the expression:

(long)Math.floor(a + 0.5d)
Special cases:

• If the argument is NaN, the result is 0.
• If the argument is negative infinity or any value less than or equal to the value of Long.MIN_VALUE, the result is equal to the value of Long.MIN_VALUE.
• If the argument is positive infinity or any value greater than or equal to the value of Long.MAX_VALUE, the result is equal to the value of Long.MAX_VALUE.

Sine

sin(75)

Returns the trigonometric sine of an angle. Special cases:

• If the argument is NaN or an infinity, then the result is NaN.
• If the argument is zero, then the result is a zero with the same sign as the argument.

Tangent

tan(66)

Returns the trigonometric tangent of an angle. Special cases:

• If the argument is NaN or an infinity, then the result is NaN.
• If the argument is zero, then the result is a zero with the same sign as the argument.

Tiered Rate

TieredRate("myTable", "09/07/2011", 125,256.36)

/*
 * Only the last key in the table is used for tiered
 */
Hashtable<Double, Double> rateTable =
    model.resolveRate(
      tableName,
      getEqu().getBaseDate(),
      baseAmount.doubleValue());