Udostępnij za pośrednictwem


Operator Functions (Report Builder)

Use the Operator functions to calculate basic mathematical values. For example, suppose you want to determine whether your team is staying on budget for a project. Using the GREATER THAN OR EQUAL TO function, you can compare the budgeted value to the actual value to determine whether the project is exceeding the budget or not.

Operator functions can use the following data types: DateTime, String, Decimal, Float, EntityKey, and Integer.

In This Section

Topic Description

ADD (Report Builder)

Use to add two or more numbers together.

DIVIDE (Report Builder)

Use to divide numbers.

EQUAL TO (Report Builder)

Use to equate two values.

EXPONENTIATION

Use to raise a value to a power.

GREATER THAN (Report Builder)

Use to indicate that one value is greater than another value.

GREATER THAN OR EQUAL TO (Report Builder)

Use to indicate that one value is greater than or equals another value.

LESS THAN (Report Builder)

Use to indicate that one value is less than another value.

LESS THAN OR EQUAL TO (Report Builder)

Use to indicate that one value is less than or equals another value.

MULTIPLY (Report Builder)

Use to multiply numbers.

NEGATE (Report Builder)

Change the sign of the value.

NOT EQUAL TO (Report Builder)

Use to indicate that two values do not equal each other.

SUBTRACT (Report Builder)

Use to deduct an item from another item.

See Also

Concepts

Using Functions (Report Builder)
Working with Formulas (Report Builder)
Report Builder How-to Topics

Help and Information

Getting SQL Server 2005 Assistance