Business Intelligence v3.0 Fast Calculation

Discussion in 'Business-Intelligence' started by avreporter, Jul 10, 2014.

  1. avreporter

    avreporter Administrator Staff Member

    Business Intelligence v3.0 Fast Calculation
  2. avreporter

    avreporter Administrator Staff Member

    Fast Calculation Functions:
    Abs Returns the absolute value of a specified number. Abs(-1)
    Acos Returns the angle whose cosine is the specified number. Acos(1)
    Asin Returns the angle whose sine is the specified number. Asin(0)
    Atan Returns the angle whose tangent is the specified number. Atan(0)
    Ceiling Returns the smallest integer greater than or equal to the specified number. Ceiling(1.5)
    Cos Returns the cosine of the specified angle. Cos(0)
    Exp Returns e raised to the specified power. Exp(0)
    Floor Returns the largest integer less than or equal to the specified number. Floor(1.5)
    IEEERemainder Returns the remainder resulting from the division of a specified number by another specified number. IEEERemainder(3, 2)
    Log Returns the logarithm of a specified number. Log(1, 10)
    Log10 Returns the base 10 logarithm of a specified number. Log10(1)
    Max Returns the larger of two specified numbers. Max(1, 2)
    Min Returns the smaller of two numbers. Min(1, 2)
    Pow Returns a specified number raised to the specified power. Pow(3, 2)
    Round Rounds a value to the nearest integer or specified number of decimal places. The mid number behaviour can be changed by using EvaluateOption.RoundAwayFromZero during construction of the Expression object. Round(3.222, 2)
    Sign Returns a value indicating the sign of a number. Sign(-10)
    Sin Returns the sine of the specified angle. Sin(0)
    Sqrt Returns the square root of a specified number. Sqrt(4)
    Tan Returns the tangent of the specified angle. Tan(0)
    Truncate Calculates the integral part of a number. Truncate(1.7)
    in Returns whether an element is in a set of values. in(1 + 1, 1, 2, 3)
    if Returns a value based on a condition. if(3 % 2 = 1, 'value is true', 'value is false')

Share This Page