Using Actuate BIRT Viewers : Functions and operators : Operators : Operators in computed column expressions
 
Operators in computed column expressions
Table 11‑2 lists the operators you can use when you write expressions for a computed column.
Table 11‑2 Operators in computed column expressions
Operator
Use to
Example
+
Add two or more numeric values together.
[OrderAmount] + [SalesTax]
Subtract one numeric value from another.
[OrderAmount] ‑ [Discount]
*
Multiply numeric values.
[Price] * [Quantity]
/
Divide numeric values.
[Profit]/12
^
Raise a numeric value to a power.
[Length]^2
%
Specify a percent.
[Price] * 80%
=
Test if two values are equal.
IF([ProductName] = "1919 Ford Falcon", "Discontinued Item", [ProductName])
>
Test if one value is greater than another value.
IF([Total] > 5000, [Total]*15%,
[Total]*10%)
<
Test if one value is less than another value.
IF([SalePrice] < [MSRP], "Below MSRP", "Above MSRP")
>=
Test if one value is greater than or equal to another value.
IF([Total] >= 5000, [Total]*15%, [Total]*10%)
<=
Test if one value is less than or equal to another value.
IF([SalePrice] <= [MSRP], "Below or equal to MSRP", "Above MSRP")
AND
Test if two or more conditions are true.
IF(([Gender] = "Male" AND [Salary] >= 150000 AND [Age] < 50), "Match found", "No match")
OR
Test if any one of multiple conditions is true.
IF(([City] = "Boston") OR ([City] = "San Francisco"), "U.S.", "Europe and Asia")
&
Concatenate string values.
[FirstName] & " " & [LastName]