Operators supported in computed measure expressionsTable 4-4 lists the operators you can use when you write an expression for a computed measure.
[OrderAmount] + [SalesTax] Subtract one numeric value from another. [OrderAmount] - [Discount] 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") IF([Country] <> "USA", "Imported product", "Domestic product") [FirstName] & " " & [LastName] IF(([Gender] = "Male" AND [Salary] >= 150000 AND [Age] < 50), "Match found", "No match") Test if any one of multiple conditions is true. IF(([City] = "Boston") OR ([City] = "San Francisco"), "U.S." , "Europe and Asia")
|
|
Copyright Actuate Corporation 2012 |