Operators in computed column expressions
Table 11-2 lists the operators you can use when you write expressions for a computed column.
[OrderAmount] - [Discount]
IF([ProductName] = "1919 Ford Falcon", "Discontinued Item", [ProductName])
IF([SalePrice] <= [MSRP], "Below or equal to MSRP", "Above MSRP")
IF(([Gender] = "Male" AND [Salary] >= 150000 AND [Age] < 50), "Match found", "No match")
IF(([City] = "Boston") OR ([City] = "San Francisco"), "U.S.", "Europe and Asia")

Additional Links:

Copyright Actuate Corporation 2012